Date Formats |
Dates can be represented by five (5) different formats. They are:
|
Format |
Description |
|
_DDMMM |
VISTA compatability for current date (Also known as "~TODAY" |
|
~DDMMM |
Common 'reconciled' version of VISTA date |
|
~TODAY |
Displays "Todays" date. If Today is April 3rd, 2002, the date displayed would be: 03APR |
|
~YESTERDAY |
Displays "Yesterdays" date. |
|
~TOMORROW |
Displays "Tomorrows" date. |
Dates can be modified with by specifying a simple expression.
The simple expression can be +/-'n' days, where 'n' is an integer.
For example:
_DDMMM+7 will give you the date of the computer plus seven days (Effectively, next week)
_DDMMM-3 will give you the date of the computer minus 3 days.
In addition to specifying a date, you can also override/specify the format of the date with a format specifier.
The format specifier is enclosed in square brackets ([]). Details of the values that can be specified in the brackets can be found in the Date Time Format Strings section.
For Example:
~TODAY[dmmm] will result in today's date formatted as day/month, with no leading zero.
~TODAY[ddmmm] will result in today's date formatted as day/month, with a leading zero on the day.
~TODAY[mmmm] will result in the current month in long format