If-then-else Empty Date Field 1

[Bennie47250]

I have an If Then Else statement that is for a date field. For the else part of the formula I would like to put in a blank something like ToText(“”) but Crystal throws the error “A date-time is required here.

Ultimately this is being exported to Excel, when it is opened in Excel I would like to see a blank field rather than anything else

Any tips how I can get a blank field when the else part of the statement is used.
Thanks

 

[hilfy]

You'll have to convert the date to text in order to do this - I believe Excel will still see it as a date. It would look something like this:

ToText({date field}, 'MM/dd/yyyy')

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[Bennie47250]

hilfy,

Thought I tried that yesterday and Excel did still treated it as a date field. However today I used "...then toText({MyField.MyTable},"M/dd/yy') else"" and Excel is seeing the field as text so mission accomplished.

Thanks