[Emerald] date format in CR6 formulas

Josh Hillman ( (no email) )
Sat, 24 Apr 1999 13:37:54 -0400

Our Emerald Invoice.rpt file has a couple formulas in it that display a few
dates along with some text. At the moment the invoices will only display
those dates in the form m/d/yy unless the date format in the Regional
Settings of the Control Panel are changed to m/d/yyyy. Is there a way in
CR6 to force dates (as part of formulas) to display as m/d/yyyy without
depending on the Regional Settings values for the particular client machine?
I already took care of simple date fields in the report and they display as
m/d/yyyy without changing the Regional Settings, but I can't figure out why
the formula dates only change when the Regional Settings format changes.
Here's an example formula:
"Billing / Service period: " + ToText({Invoices.StartDate}) + " - " +
ToText({Invoices.EndDate})

Before changing the regional settings, it outputs like:
Billing / Service period: 12/1/98 - 1/1/99
After changing the Regional Settings, it outputs like:
Billing / Service period: 12/1/1998 - 1/1/1999

I don't want the date format (in formulas) on the invoices to be dependent
on what settings the Emerald client computer happens to have set.

Thanks,
Josh