Keystroke Point of Sale Help

Reports and Labels - Filters and Formula Functions - Date Text

Syntax - @DATETEXT(Numeric Date)

Parameters - Numeric Date - Serialized date in the format ####.

Action - Converts a serialized (numeric date) to a Date String (usually MM/DD/YY). When a date is used in a formula, it is changed to a serialized number (the number of days since 12/31/1984) so that days can be added to or subtracted from it. This function can then be used to display the date in a more readable format.

Example - @DATETEXT(7975)

Result - Returns the date 11/01/06. The format for dates can be changed in Configuration Manager, under the Settings Menu, in the Global Parameters.


Filters and Formula Functions - All

Filters and Formula Operators

Filters - Transaction Types

Keystroke Help Table Of Contents