@AGEDATE | converts an NTFS file age into a date and time |
@CENTURY | returns the century number for a date or for a year |
@DATE | converts a date into a day number |
@DATECONV | converts a date from one format into another |
@DATEPLUS | adds a number of days to a date |
@DAY | returns the day of the month for a date |
@DAYS | returns the difference in days between two dates |
@DECTOTIME | converts a decimal day fraction to hours, minutes, and seconds |
@DOW | returns the abbreviated name of the day of the week for a date |
@DOWF | returns the full name of the day of the week for a date |
@DOWI | returns the day of the week for a date as a number |
@DOWIS | tests whether a date matches specified days of the week |
@DOY | returns the day of the year for a date |
@EASTER | returns the date of Easter for the specified year |
@FILESTAMP | returns a file’s date and time stamps, correctly localized |
@HOLIDAY | returns the date of a specific day of the week within a month |
@IDOW | returns the abbreviated local name for the day of the week for a date |
@IDOWF | returns the full local name for the day of the week for a date |
@INLIEU | substitutes a weekday for a weekend date |
@INRANGE | tests whether a date falls within a range |
@ISDATE | returns 1 if its argument is a valid date, 0 otherwise |
@ISHOLIDAY | returns 1 if its argument is an annual holiday, 0 otherwise |
@ISODOWI | returns the day of the week for a date as an integer, per ISO 8601 |
@ISOWEEK | returns the ISO 8601 week number for a date |
@ISOWYEAR | returns the ISO 8601 week-numbering year for a date |
@ISTIME | returns 1 if its argument is a valid time, 0 otherwise |
@JULIAN | converts a date into a day number |
@LEAP | return 1 if a year is leap, 0 if common |
@LOCALDATETIME | converts a UTC date and time to the local time zone |
@MAKEAGE | converts a date and time into an NTFS file age |
@MAKEDATE | converts an MS-DOS day number to a date |
@MONTH | returns the month number for a date |
@MONTHLEN | returns the number of days in a given month |
@MONTHNAME | returns the name of a month |
@NEXTDATE | returns the next date matching a specified month and day |
@NEXTDOW | returns the next day matching a specified day of the week |
@ORD | returns a number with an English ordinal suffix |
@PICKDATE | allows the user to select a date from a popup calendar |
@ROMAN | converts an integer to a Roman numeral, or vice versa |
@TIMEDIFF | subtracts one time from another and returns the difference |
@TIMEFMT | formats a time for display |
@TIMEPARTS | parses a time and indicates which parts were specified |
@TIMEPLUS | adds an offset to a time |
@TIMETODEC | converts a time into a decimal fraction of a day |
@USECONDS | converts a date and time to seconds past the Unix epoch |
@USWEEK | returns a week number for a given date |
@UTCDATETIME | converts a local date and time to UTC |
@UXTODATETIME | converts a Unix time stamp to a date and time |
@YEAR | returns the year for a date |