Keystroke Point of Sale Help


Reports and Labels - Filters and Formula Functions - DateVal

Syntax - @DATEVAL()

Parameters - (+1M, -5D, 99, etc.)

Action - Accepts standard Keystroke date notation to represent a date based on the current date (e.g. +1M, -5D, 99, etc) and returns the date in numeric date value (####) so it can be compared to other dates. For example, "CST:ExpDate>0 and CST:ExpDate<@DateVal(+5)" may be used to include customers that have an Expiration Date that has or will expire in the next 5 days.

Example - @DATEVAL(+5)

Result - Returns the date 5 days from the current date in numeric date format.

See:

Filters and Formula Functions - All

Edit Variable Screen

Variables in SubTotals and Grand Totals

Filters and Formula Operators

Filters - Transaction Types

Keystroke Help Table Of Contents