General Date & Time

_Date()

• Purpose: Retrieves the current system date.

• Syntax: __Date()

_DateTime()

• Purpose: Retrieves the current system date and time.

• Syntax: __DateTime()

_Time()

• Purpose: Retrieves the current system time.

• Syntax: __Time()

Manipulation

_DateAdd(d_m_yyyy_n_s_h, n, date)

• Purpose: Adds or subtracts a specified interval to a date.

• Syntax: __DateAdd("Interval", Value, "Start_Date")

  • Intervals: "d" (days), "m" (months), "yyyy" (years), "n" (minutes), "s" (seconds), "h" (hours).

  • Value: Can be positive (add) or negative (subtract).

• Example: __DATEADD("d", 10, "02-10-2018")

_DateDiff(d_m_yyyy_n_s_h, Date1, Date2)

• Purpose: Calculates the difference between two dates in a specified interval.

• Syntax: __DateDiff("Interval", "Date1", "Date2")

  • Intervals: Same as in _DateAdd

• Example: __DATEDIFF("d","02-10-2018","03-22-2018")

_Timer()

• Purpose: Gets the time in milliseconds since the application was initiated.

• Syntax: __Timer()

Extracting Date/Time Components

_Day(datetime)

• Purpose: Extracts the day from a date/time value.

• Syntax: __Day("Date/Time Value")

_Hour(datetime)

• Purpose: Extracts the hour from a date/time value.

• Syntax: __Hour("Date/Time Value")

_Minute(datetime)

• Purpose: Extracts the minute from a date/time value.

• Syntax: __Minute("Date/Time Value")

_Month(datetime)

• Purpose: Extracts the month (as a number) from a date/time value.

• Syntax: __Month("Date/Time Value")

_Second(datetime)

• Purpose: Extracts the second from a date/time value.

• Syntax: __Second("Date/Time Value")

_Year(datetime)

• Purpose: Extracts the year from a date/time value.

• Syntax: __Year("Date/Time Value")

Formatting & Names

_FormatDate(date, format)

• Purpose: Reformats a date according to a provided format string.

• Syntax: __FormatDate("Date Value", "Format String")

• Example: __FORMATDATE("02-10-2018", "M yy")

_MonthName(date)

• Purpose: Returns the month's name for a given date.

• Syntax: __MonthName("Date Value")

_WeekDay(date)

• Purpose: Returns the day of the week (as a number) for a given date.

• Syntax: __WeekDay("Date Value")

_WeekDayName(date)

• Purpose: Returns the day of the week's name for a given date.

• Syntax: __WeekDayName("Date Value")