To work with the tool in Foresight Analytics Platform 10, use the new interface.

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 matching 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 hour, minute and second.
TimeValue	It returns the result of string value converting to the TimeSpan dialog box opens.
Today	It returns date for the current moment in time.
Weekday	It returns the number of a weekday based on the specified date.
Year	It returns the year based on the specified date.