Date and Time Formats

Date and Time Formats

You can either enter a date/time in the input field or drag-drop a data from another source.

Input Formats

When you enter a date, it should be in Automate IOs standard format. 

  • 05-Dec-2018 - Date only format
  • 05-Dec-2018 09:15:00 - Date & time

Output Format

When you use date/time coming from some other source (like Trigger output fields or Action output fields), we convert the date to the standard format.

Date: 12-May-2016

Date Time: 12-May-2016 21:30:10
 

Modifying Dates 

Changing Date Format

Use the Formatter app 'Format Date' action to change the date format.


Add / Subtract Time

You add or subtract a certain amount of time to any data in the Output fields. For example, if you wish to add 1 day to an output field date, add ' +1d' (without quotes and with a space before the '+' )

Some examples of codes you can use

  • Code for adding one hour +1h
  • Code for adding 15 minutes +15m
  • Code for adding one-day, 6 hours and 10 minutes would be +1d +6h +10m (space before each + sign)
  • Code for subtracting 5 hours would be -5h