UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Formatting a calculated date in a report    
 
   
Adam858
post Jul 30 2010, 07:09 AM
Post #1

UtterAccess Member
Posts: 27
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

This post has been edited by Adam858: Jul 30 2010, 07:31 AM
Go to the top of the page
 
+
Alan_G
post Jul 30 2010, 07:35 AM
Post #2

Utterly Yorkshire and Forum/Wiki Editor
Posts: 15,895
From: Devon UK
Hi

Try

CODE
....letter text " & Format(([Forms]![Main Switchboard]![QueDays]+[ArrivalDate]),"dd mmm yyyy") & " letter text.....
Go to the top of the page
 
+
Adam858
post Jul 30 2010, 07:42 AM
Post #3

UtterAccess Member
Posts: 27
Alan you are a genius (IMG:style_emoticons/default/yayhandclap.gif)

It works, you've saved the day!

Cheers

Adam
Go to the top of the page
 
+
Alan_G
post Jul 30 2010, 07:58 AM
Post #4

Utterly Yorkshire and Forum/Wiki Editor
Posts: 15,895
From: Devon UK
Hi Adam

No problem - glad you got it working (IMG:style_emoticons/default/wink.gif)
Go to the top of the page
 
+
« Next Oldest · Access Date + Time · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 07:40 PM