06.D Date Manipulation Built-In Functions

 

AddDays

Returns a date by adding the given number of days to the input date

AddMonths

Returns a date by adding the given number of months to the input date

AddYears

Returns a date by adding the given number of years to the input date

DateDiff

Returns the number of days between two dates

DateVal

Returns a date value from the input numeric variables of year, month, and day

DateMMDDYY

Returns a string of the format "MM/DD/YYYY" from the input date

Day

Returns the day from the input date

DayOfWeek

Returns the day of the week (1-7) from the input date

DayOfYear

Returns the day of the year (1-366) from the input date

FirstOfMonth

Returns a date which is the first day of the month of the input date

LastOfMonth

Returns a date which is the last day of the month of the input date

MMDDYYToDate

Returns a date value from the input string in the format "MM/DD/YYYY"

Month

Returns the month from the input date

MonthDay

Returns a string of the format "MM/DD" from the input date

PopupDate

Prompts the user for a date using the standard date request popup

SubtractDays

Returns a date by subtracting the given number of days from the input date

SubtractMonths

Returns a date by subtracting the given number of months from the input date

SubtractYears

Returns a date by subtracting the given number of years from the input date

ToDate

Returns a date value from the input string which is in the format "YYYY/MM/DD"

Today

Returns a date from the computer which is today's date

Year

Returns the year from the specified date

YearMonth

Returns a string of the format "YY/MM" from the specified date