Date constants can be formatted in any of the following ways:
•mm/dd/yy (or dd/mm/yy if that setting is specified)
•mm/dd/yyyy (or dd/mm/yyyy ditto)
•either of the above with dots (.) in place of slashes (/)
•yyyy-mm-dd
•yyyy.mm.dd
•yyyymmdd
•dd-mmm-yy (where mmm is the first three letters of the month name)
•dd-mmm-yyyy (ditto)
•Earliest (use the earliest available date as a StartDate)
•Latest (use the latest available date as an EndDate)
Date constants are used in the Import, and Scan Settings, and Test Settings script sections.
When using a date in a formula, e.g. iif(Date==20200607), it is simply a number and must therefore be formatted as YYYYMMDD.
If you prefer, you can use ToDate to convert date strings in any of the above formats (except Earliest and Latest) to numbers.
Any type of CSV files that RealTest reads can use any of the above formats (other than "Earliest" and "Latest") in their Date column values.
|