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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> change date format    
 
   
him5002
post Jun 4 2008, 09:08 AM
Post #1

UtterAccess Addict
Posts: 166
Hi,
How do i change the format of a date from 1/12/2008 to just 1/2008 in a query? I have a whole field of dates and need to change the format of all of them. Thanks in advance for your help!
Go to the top of the page
 
+
niesz
post Jun 4 2008, 09:11 AM
Post #2

Utter A-fishin'-ado
Posts: 17,723
From: Cincinnati, Ohio, USA . . . ><((((°>
I'll assume you just want to change they way they display, and not update the original values.

If so, try:

Format([YourDateField),"m/yyyy")
Go to the top of the page
 
+
him5002
post Jun 4 2008, 09:27 AM
Post #3

UtterAccess Addict
Posts: 166
Ok, great, that worked! Thanks for your help!
Go to the top of the page
 
+
niesz
post Jun 4 2008, 09:27 AM
Post #4

Utter A-fishin'-ado
Posts: 17,723
From: Cincinnati, Ohio, USA . . . ><((((°>
NP.
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: 25th May 2013 - 06:19 PM