Edit

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