72149 - DQL:- Date Format
| Reported by: | Tim Hammond | When: | 4th February 2010 - 11:58 |
|---|---|---|---|
| Operating system: | Windows 7 | DataEase version: | DataEase 7.2.2 |
| Status: | Now fixed |
If you use a calculated date in list records (see below) when the report is run the date displayed in standard format is 01/02/20 instead of 01/02/10.
if ( InvoiceSuffix = "V" , InvoiceDate + 7 , InvoiceDate + 14 )
To get around the problem you will need to assign the above date calculation to a Temp of Global variable first and include the variable in the list records.
Example sent.