Date Mask Help

[kbbdnc]

I have a date mask problem. I am working with a report in CR8 that is tied to an Access97 database that I cannot control, therefore I do not know what format the date resides in at the field level. Here is the mask attempt I am trying to force to work:

If IsNull({Requests for Information.RFI~DateRequired}) Then
{@lng.DateRequired:} + " " + ""
Else
{@lng.DateRequired:} + " " + ToText ({Requests for Information.RFI~DateRequired}, "mm,/dd,/yyyy"

Any suggestions?

Thanks-

 

[kenhamady]

What data type is the field:
{Requests for Information.RFI~DateRequired}

(not in the database, but as recognized by the report)



Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[kbbdnc]

Thanks Ken,

The date mask that I was using actually did work, I can't view the report in crystal reports, I actually have to go to the custom program to view it, and the changes did eventually filter down to the version within the custom program, there was just a delay.