A collection of useful date and time actions.

 

dtDayNum

Purpose:

Returns the current day of the month as a number (1-31).

Category:

Date & Time

Syntax:

dtDayNum [result]

 

result

Variable to store result

 

dtDayName

Purpose:

Get the current weekday name (Sunday, Monday, Tuesday...)

Category:

Date & Time

Syntax:

dtDayName [result]

 

result

Variable to store result

 

dtDayNumToName

Purpose:

Convert day number (1-7) to day name (Sunday, Monday...).

Category:

Date & Time

Syntax:

dtDayNumToName daynum [result]

 

daynum

Day number (1-7)

result

Variable to store result

 

dtWeekDayNum

Purpose:

Get the current weekday as a number (1-7).

Category:

Date & Time

Syntax:

dtWeekDayNum [result]

 

result

Variable to store result

 

dtMonthNum

Purpose:

Get the current month as a number (1-12).

Category:

Date & Time

Syntax:

dtMonthNum [result]

 

result

Variable to store result

 

dtMonthName

Purpose:

Get the current month name (January, February, March...).

Category:

Date & Time

Syntax:

dtMonthName [result]

 

result

Variable to store result

 

dtMonthNumToName

Purpose:

Convert month number (1-12) to month name (January, February, March...).

Category:

Date & Time

Syntax:

dtMonthNumToName monthnum [result]

 

monthnum

Month number (1-12)

result

Variable to store result

 

dtYear

Purpose:

Get the current four digit year (yyyy).

Category:

Date & Time

Syntax:

dtYear [result]

 

result

Variable to store result

 

DateDifference

Purpose:

Calculate the number of days between two dates.

Category:

Date & Time

Syntax:

DateDifference "date1" "date2" "format" [result]

 

date1

First date

date2

Second date

format

Date format (mm/dd/yyyy, dd/mm/yyyy, etc.)

result

Variable to store result

 

dtLocalDate

Purpose:

Transform a date into a local date format

Category:

Date & Time

Syntax:

dtLocalDate year month day [result] "locale"

 

year

Year (YYYY)

month

Month (MM)

day

Day (DD)

result

Variable to store result

locale

Locale (optional) ie: en-US