Date and Time

The list of predefined functions for working with date and time is shown in the table below:

Function	Brief description
Date	It returns the date by the specified year, month and day.
DateValue	It returns the result of converting a string into a date.
Day	It returns day number in the month.
Edate	It returns the date increased/decreased by the specified number of months.
Hour	It returns an hour for the specified time.
Minute	It returns minutes for the specified time.
Month	It returns a month for the specified date.
Now	It returns the current date and time.
Second	It returns seconds for the specified time.
Time	It returns time by the specified hours, minutes and seconds.
TimeValue	It returns the result of string value converting into the TimeSpan type.
Today	It returns date for the current moment in time.
Weekday	It returns the number of a weekday for the specified date.
Year	It returns a year for the specified date.