Working with Dates in logic editor

Following commands are helpful to work with dates in action logic editor. These date commands support a standard set of date formats.

1. mm/dd/yyyy
2. mm/dd/yy
3. dd/mm/yyyy
4. dd/mm/yy
5. dd mmm yyyy

If you have a requirement to work with a format that is not listed, use the command for date format conversion.

Find Current Date

Get Current Date

Returns current date in the given format. Supports date formats: mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy.

Format 

Returns

Select date format option (mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy).

Current date in the given format

Get Current Time

Returns the current time in a given format(12/24 hrs).

Time Format

Returns

12/24 hour format

Current Time in the given format

Find Future/Past Date

Add to Current Date

Returns a future or past date relative to current date based on the provided offset. If the number of days is negative, a date in the past is returned. Supports date formats: mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy.

N
 
Format

Returns

Number of days to add to current date. Negative value indicates past date.

Select date format option (mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy).

Future/past date in the given format.

Add to Current Time

Returns a future or past time relative to current time based on the provided offset. If the number of hours/minutes is negative, a time in the past is returned.

Time Format

Time 
 
Unit

Returns

12/24 hour format
 
Time to add
 
Minutes or hours

Future/past Time in the given format.

Date
 
 N
 
format

Returns

Date to which the given number of days to be added.
 
Number of days to add to the given date. Negative value indicates past date.
 
Select date format option (mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy).

Future/past date relative to the given date in the given format.

Get Days Between

Returns number of days between given dates. Returns positive number if the to date is later than from date, otherwise negative number. Supports date formats: mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy.

From date
 
To date
 
Format

Returns

Starting date
 
End date
 
Select date format option (mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy)

Number of days between the given dates

Parse date components

Get Day from Date

Returns day of given date. Supports date formats: mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy.

Format
 
Date

Returns

Date format in which the date input is given

Date input

Day of given date.

Get day-of-week

Returns day-of-week for the given date. Supports date formats: mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy.

Date
 
Format

Returns

Date string.
 
Select date format option (mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy).

Name of the day-of-week for given date.

Get day-of-week (short)

Returns day-of-week in short notation for the given date. Supports date formats: mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy.

Date
 
Format

Returns

Date string.
 
 Select date format option (mm/dd/yyyy, mm/dd/yy, dd/mm/yyyy, dd/mm/yy, dd mmm yyyy).

Name of the day-of-week for given in short notation.

...