I have a text field in a report that contains a letter. In this letter is a date that is caluclated based on a control on the main switchboard.
....letter text" & " " & ([Forms]![Main Switchboard]![QueDays]+[ArrivalDate]) & "letter text.....
I want this to show up as the long date format (eg 10 July 2010) not in the default format (e.g. 13/07/2010 08:11:55).
How do I achieve this guys?
Thanks in advance