Date-times: Convert a date to a date-time

Use this action to convert a date to a date-time. This action can add minutes and hours to a date and format it as a date-time.

This action can help you ensure that a field is in the correct format, before using additional actions that require that format

How to configure this action

Since this action converts a date to a date-time, the time is added as hours and minutes during action configuration. If the hours and minutes are not entered, the output will hours and minutes will default to 12:00AM

Fields for this action

• Input date

  • A date to convert, inputted or in the {{field-name}} format
    • For example, 2018-03-01

• Timezone identifier

  • The timezone identifier based on location
    • For example, ‘America/Chicago’ would represent US Central Time
    • You can browse our list of valid timezone identifiers

• Hours

  • Integer number of hours to add or subtract
  • A positive integer will add hours while a negative integer will subtract hours

• Minutes

  • Integer number of minutes to add or subtract
  • A positive integer will add minutes while a negative integer will subtract minutes

• Output field name

  • The name of the field in which the result should be saved. The step name is used by default.

What will this output?

This action will output the converted date-time value in the YYYY-MM-DD HH:MM AM format. The name of the output field will be the Output field name defined during configuration.

The output time zone is always converted to the current time zone. If the output time looks strange, confirm that the Timezone Identifier is in the correct time zone.

Output fields for this action

• Return Field Name

  • The converted date & time in the YYYY-MM-DD HH:MM AM format.