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
Edit Variable Screen
Variables in SubTotals and Grand Totals
Filters and Formula Operators
Filters - Transaction Types