Open navigation

How can I convert date and time values?

Modified on: Thu, Aug 8, 2019 at 5:09 PM

You may need to adjust the columns in your worksheet to reflect different values of similar types, like date, time, and datetime values.
This can be done quickly and effectively to make sure that your data is coded correctly for your needs in DSCVR. 

To convert your data to a Date value:

  1. In the Toolbox option, select the Column Formatting operation.
  2. Select the worksheet column you want to convert to a date value.
  3. Under the Display Format option, click the dropdown and scroll to the Date section.
  4. Select the specific form of Date field you want to use when converting this column.
  5. Click the Run button to convert this column.



For the Date field, you have the option of selecting from Date (10/15/17), Date w/ 4 Year (10/15/2017), and ANSI Date (2017-10-15) formats.

To convert your data to a Time value:

  1. In the Toolbox option, select the Column Formatting operation.
  2. Select the worksheet column you want to convert to a time value.
  3. Under the Display Format option, click the dropdown and scroll to the Time section.
  4. Select the specific form of Time field you want to use when converting this column.
  5. Click the Run button to convert this column.



For the Time field, you have the option of selecting from Hours, Minutes, Seconds 24 Hour (20:25:30), Hours, Minutes, Second 12 Hour (10:25:30pm), Hours Minutes 24 Hour (20:25), and Hours, Minutes 12 Hour (10:25pm) formats.

To convert your data to a Date Time value:

  1. In the Toolbox option, select the Column Formatting operation.
  2. Select the worksheet column you want to convert to a date time value.
  3. Under the Display Format option, click the dropdown and scroll to the Date Time section.
  4. Select the specific form of Date Time field you want to use when converting this column.
  5. Click the Run button to convert this column.



For the Date Time field, you have the option of selecting from Date and Time 24 Hour (10/15/17_20:25:30) and Date and Time ANSI 12 Hour (2017-10-15 10:25:30) formats.

Once the operation runs, the selected column will be converted to the intended value.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.