Format field 1

[durug]

Hi list!

I have a formula field something like this:
IF {sp_Report.Required_Ship_Date} = Date (1940,01,01) THEN
"Past Due"
ELSE
ToText({sp_Report.Required_Ship_Date})

The problem that I have is that I would like to display the
sp_Report.Required_Ship_Date in this format:
March 1, 2002 in else case. Riht now is like this 3/1/2002 12:00:00. And I don't wan't to change the computer settings.

How can I do this?

thanks,
Durug

 

[DanR]

try this:

IF {sp_Report.Required_Ship_Date} = Date (1940,01,01) THEN
"Past Due"
ELSE
ToText({sp_Report.Required_Ship_Date}, "MMMM, d, yyyy&quot

The "M's" must be capitalized, as a lowercase m is for minutes.