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

Категории