About    Download    Order    Support

Recent News

InnPlanner 2010 Released New faster database engine, more customization features, weekly tariffs, full multi-user work support and much more... 2010 Feb 10

InnPlanner 2010 RC1 InnPlanner 2010 Release Candidate 1 is ready for downloading and testing. You can download it from the "Downloads" section. 2010 Jan 14

Hotel Software Documentation

Date Functions

Date Functions

Note. Date functions use their own internal numeric representation of dates. However, the mode of the date representation can by modified so that the result of the formula is displayed as a date, instead of numerals. To modify the mode use the formatting string starting with word Date (not Math), e.g. "date dddd, mmm d yyyy" will be displayed as Monday, Feb 2 2004. 

dateSerial (Year, Month, Day)

Returns date for the specified year, month, and day. The function converts the date specified by year, month, and day into the internal format.

Examples:

datePart(dateSerial(1983,4,16),|Year|), returns 1983;

datePart(dateSerial(1983,4,16,|Day|), returns 16.

datePart (Date, |Part|)

Returns specified part of the date.

Examples:

datePart(dateSerial(1983,4,16),|Year|), returns 1983;

datePart([Order Date],|Month|), returns month of the date stored in the record field value with name "Order Date".

dateCurrent()

Returns the current system date. The function converts the date specified by year, month, and day into the internal format. The return value may only be used within the application.

Examples:

datePart(dateCurrent()), returns today's day;

dateDiff (dateA, dateB, |Interval|)

Returns the value specifying the number of time intervals between two dates specified. The interval parameter contains the interval of time to calculate the difference between dateA and dateB.

Examples:

dateDiff(dateSerial(2004,10,20), dateSerial(2004,10,16), |Day|), returns 20-16=4

dateDiff(dateSerial(dateCurrent(), [Order Date], |Month|), returns the number of months since the date stored in the record field value with name "Order Date".

dateAdd (dateA, Interval_len, |Interval|)

Returns the date shifted from date dateA to a specified interval Interval_len defined in days, months or years. The unit measure is defined by parameter Interval.

 Examples:

dateAdd(dateSerial(2004,1,1),5,|Day|), returns 6 January 2004

dateAdd(dateSerial(2004,1,1),32,|Day|), returns 2 February 2004

dateAdd(dateSerial(2004,1,1),2,|Month|), returns 1 March 2004

Today"s Poll

What software do use for your inn/b&b/hotel/etc?

Home Page | Contacs | Terms and Conditions

Copyright (C) 2001-2010 Binary Brilliant Inc