Page 1 of 1
Format date field to blank
Posted: Thu Sep 25, 2003 10:17 am
by 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
=> RE: Format date field to blank
Posted: Thu Sep 25, 2003 10:23 am
by 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!
==> RE: Format date field to blank
Posted: Tue Sep 30, 2003 11:23 am
by 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.
===> RE: Format date field to blank
Posted: Tue Sep 30, 2003 12:10 pm
by 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__