MoneyWorks Manual
Date (day, month, year)
Result Type: Date
Definition: Returns a date made from the supplied day number, month number and year.
Examples: Date(21, 2, 2008)
returns 21/2/2008.
Date(1, 1, Year(Today) + 1)
returns the first day of next year.
Notes: A 2 digit year between 41 and 99 will be assumed to be 1900 + the year value. A 2 digit year between 0 and 40 will be assumed to mean 2000 + the year value. You should use 4 digit years. Results for day values outside the range (1-number of days in the month) are not defined. Results for month values outside the range (1-12) are not defined prior to MoneyWorks 9.1.7. From 9.1.7 onwards, months <= 0 or > 12 will make a date in a year relative to the one specified (e.g. month 0 will give you December in year - 1; month 13 will give you January in year + 1).
See Also:
CalcDueDate: Calculate a due date for given terms
CurrentPeriod: Get the current period number
DateToPeriod: Convert a date to a period
DateToText: Format a date as a string
Day: Get the Day of month of a date
DayOfWeek: Get The weekday of a date
FirstUnlockedPeriod: Get the oldest period that is not locked
Month: Get the month of a date
PeriodName: Get the Name of a period
PeriodOffset: Difference between two periods
PeriodToDate: Get the end date of a period
TextToDate: Parse a string to a date
Time: The current Datetime
TimeAdd: Add seconds to a DateTime
TimeDiff: The difference, in seconds, between two DateTimes
Timestamp: A timestamp string
Today: Today's date
WeekOfYear: Convert a date to a week number
Year: Year of a date