Working with Dates
The following table summarizes the common functions used to manage dates.
Function |
Description |
Example |
---|---|---|
@Date |
Translates a series of numbers into a date value. This function requires a year, month, and day value to be specified. Syntax: @Date; |
@Date (2005; 12; 31); Result: 12/31/2005 |
@Day |
Returns the day of the month from the specified date. Syntax: @Day (date); dateAny specified date. |
@Day ("07/10/2005"); @Day (@Today); Result: 10 |
@Month |
Returns the month from the specified date. Syntax: @Month(date); dateAny specified date. |
@Month ("07/10/2005"); @Month (@Today); Result: 07 |
@Now |
Returns the current date and time. Syntax: @Now; |
@Now; Result: 07/10/2005 9:31:45 AM |
@Today |
Returns the current date. Syntax: @Today; |
@Today; Result: 07/10/2005 |
@Tomorrow |
Returns tomorrow's date. Syntax: @Tomorrow; |
@Tomorrow; Result: 07/11/2005 |
@Weekday |
Returns the day of the week based on the specified date. Returns a number corresponding to the weekday where Sunday=1, Monday=2, and so on through Saturday=7. Syntax: @Weekday (date); dateAny specified date. |
@Weekday ("07/10/2005"); @Weekday (@Today); Result: 1 |
@Year |
Returns the current year from the specified date. Syntax: @Year (date); dateAny specified date. |
@Year ("07/10/2005"); @Year (@Today); Result: 2005 |
@Yesterday |
Returns yesterday's date. Syntax: @Yesterday; |
@Yesterday; Result: 07/09/2005 |