Date Format

[Kathyrlcrs]

I have a formula for a date field. I am choosing between various date fields. If there is no table record, I would like to put in "N/A", however I have the formula in my design formatted as a date. Any suggestions on how I can do this.
Thanks for any suggestions.

 

[IdoMillet]

If IsNull({myDate}) THEN "N/A" ELSE Cstr({myDate})

You would probably want to use the optional format argument in Cstr() or ToText() to control how the date string is formatted.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Kathyrlcrs]

This is the formula I originally had:

If Not IsNull({Brokerage_Offer.ReducedDate})then
{Brokerage_Offer.ReducedDate} else
"N/A"
With this it highlights "N/A" and sends back "a date-time is required".

I tried different ways using the Cstr, could not get to work.

If there is a Brokerage_Offer.ReducedDate I want that to print, if not I want the N/A.

Can you help?

 

[IdoMillet]

Is {Brokerage_Offer.ReducedDate} a date field?

What exactly didn't "work" with Cstrt() ?

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com