Long date format in mailing report

[Chris]

Hi,

I have a mailing report with the following text box:

="Thank you for your " & Trim([Type of complaint]) & "
dated " & Trim([Date complaint raised]) & "."

It works fine, the info is picked up properly, the only
thing is the date [date complaint raised] is diplayed in
the report as 19/09/2003 (UK date: dd, mm, yyyy). I have
designed the whole database with medium dates or Long date
formats. in the property box, the format set for Long
Date. How can I have this particular date showing as 19
September 2003 instead? I have tried all sorts
unsuccessfully.

Thanks in advance.
Chris.

 

[Allen Browne]

Use the Format() function to specify the format you want:

="Thank you for your " & Trim([Type of complaint]) & " dated " &
Format([Date complaint raised], "Long Date") & "."