CALENDAR (Start Date, End Date)
Returns a table with one column of all dates between start and end date

CALENDARAUTO ([FiscalYearEndMonth])
Returns a table with one column of dates calculated from the model automatically

DATE (Year, Month, Day)
Returns the specified date in datetime format

DATEDIFF (Date1, Date2, Interval)
Returns the number of units (unit specified in interval) between the input two dates.

DATEVALUE (DateText)
Converts a date in the form of text to a date in datetime format.

DAY (Date)
Returns a number from 1 to 31 representing the day of the month.

EOMONTH (Start Date, Months)
Returns the date in datetime format of the last day of the month before or after a specified number of months

HOUR (DateTime)
Returns the hour as a number from 0 (12:00 AM) to 23 (11:00 PM)

MINUTE (DateTime)
Returns a number from 0 to 59 representing the minute.

MONTH (Date)
Returns a number from 1 (January) to 12 (December) representing the month.

NOW ()
Returns the current Time.

SECOND (DateTime)
Returns a number from 0 to 59 representing the second.

TIME (Hour, minute, second)
Converts hours, minutes, seconds given as numbers to a time in datetime format.

TIMEVALUE (TimeText)
Converts a time in text format to a time in datetime format.

TODAY ()
Returns today’s date and time.

WEEKDAY (Date, [Return Type])
Returns a number from 1 to 7 identifying the day of the week of a date.

WEEKNUM (Date, [Return Type])
Returns the week number in the year.

YEAR (Date)
Returns the year of a date as a four-digit integer.

YEARFRAC (StartDate, EndDate, [Basis])
Returns the year fraction representing the number of whole days between start_date and end_date.