How to Convert the Number to a Date in an email

[Realdude]

Hello,

Have a quick question. I need to collect data from a file and transmit it via email to our instructors. One of the fields is "Program Date". The email is set up as a text calculation field and the date is presented as that mythical number (731238). How do I get the date to read correctly?

Thanks

Dan

[LaRetta]

Hi Dan :

Modify your text calculation ... DateToText(Program Date)

LaRetta

[Vaughan]

what about Date(1, 1 + program date, 1)