Format date field to blank

[dceglenski]

How do you format a report date field to blank or spaces when the database stores the date in it^s default value of 01/01/01. ____Thanks for helping out a newbe!____dc

[Thomas_Freitas_(Guest)]

I^m not exactly sure what it is you are looking for, but a blank date can be made by the following:____{//}__dtoc(" / / ")____By the way, you should convert all your dates to 4 digit years if you have not done so yet!

[dceglenski]

The data in the database is stored as 01/01/0001. On the report I want the value to be spaces if the date is 01/01/0001. Most reporting tools support this kind of logic, (Crystal, SAS, etc.) I have not been able to find this kind of support in R&R.

[rickwjohnson]

Assuming the date field (d_date) is a character field, I would create a conditional if statement:____iif(d_date ="01/01/0001", space(10), d_date)____So, if the d_date is the default, you get 10 spaces, else you get the d_date. ____Rick Johnson__