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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Datepart To Shown Month, Office 2003    
 
   
foxtrojan
post May 6 2012, 05:42 AM
Post #1

UtterAccess Guru
Posts: 678
From: Singapore
I've this "Month: DatePart("m",[CODate])" which shows the month in numeric - 1 for Jan, 2 for Feb so on. How do make it show the month as January, February, etc?
Go to the top of the page
 
+
Alan_G
post May 6 2012, 06:07 AM
Post #2

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

That would be

CODE
FullMonth: Format([CODate], "mmmm")


or as an alternative

CODE
FullMonth: MonthName(Month([CODate]))
Go to the top of the page
 
+
foxtrojan
post May 6 2012, 01:30 PM
Post #3

UtterAccess Guru
Posts: 678
From: Singapore
Alan, thank you so much, works perfectly
Go to the top of the page
 
+
Alan_G
post May 6 2012, 01:32 PM
Post #4

Utterly Yorkshire and Forum/Wiki Editor
Posts: 15,895
From: Devon UK
(IMG:style_emoticons/default/yw.gif)
Go to the top of the page
 
+
« Next Oldest · Access Queries · 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: 18th June 2013 - 04:38 PM

Tag cloud:
#file