Hello,
I am using Crystal Reports XI and have a table with a Date Time field.
I have inserted the field into my report but, wherever the field returns a certain date, I would like to change that date into an arbitrary non-date string.
For example: if DateTime field X = 05/01/1989 0:00 then I would like to see 00/00/00 in the report.
I am trying variations of the following formula:
stringvar X = ToText({DateTime Field X}, "MM/dd/yy")
if stringvar = "05/01/89"
then stringvar = "00/00/00"
However, I run into two problems. First, Crystal Reports tells me that everything beyond the first line of the formula does "not appear to be part of the formula." Secondly, I can't figure out how do I get stringvar to appear in the report.
Any help with this vexing problem would be very much appreciated!