Date/Time to Julian

Convert Date/Time to Julian

  1. Right-click on a Date/Time field and select Time > DateTime to Julian in a context menu.

The DateTime to Julian dialog displays.

  1. Enter the value or click in Sample Row to select the row number that a sample of the convert definition that will be displayed in the Time Bucket box below.

  2. Select any of these Time Bucket options:

    • No Year

    • One Digit Year

    • Two Digit Year

    • Four Digit Year

  1. Check the Remove Original Column box to delete the original column and just display the new column with converted values instead.

  2. Click OK. The new replaced values are displayed.