UtterAccess Discussion Forums > Formatting a calculated date in a report

Full Version: Formatting a calculated date in a report

UtterAccess Discussion Forums > Microsoft® Access > Access Date + Time

Adam858

Jul 30 2010, 07:09 AM

Hi all

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

Adam

Alan_G

Jul 30 2010, 07:35 AM

Hi

Try

CODE

....letter text " & Format(([Forms]![Main Switchboard]![QueDays]+[ArrivalDate]),"dd mmm yyyy") & " letter text.....

Adam858

Jul 30 2010, 07:42 AM

Alan you are a genius

It works, you've saved the day!

Cheers

Adam

Alan_G

Jul 30 2010, 07:58 AM

Hi Adam

No problem - glad you got it working

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.