Re: Format dates

From: Bob Quintal <rquintal@xxxxxxxxxxxxx>
Date: 28 Sep 2007 20:43:48 GMT

Denis <denisphelan@xxxxxxxxx> wrote in news:1191013841.883069.75800
@n39g2000hsh.googlegroups.com:

How do you use the format function in acess to display the month part
of a date fied

format([datefield],"mm")
9

format([datefield],"mmm")
sep

format([datefield],"mmmm")
September

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.

References:
- Format dates
  - From: Denis

Prev by Date: Re: Manipulating dates
Next by Date: Re: Why is the message body of my post being deleted??? This is wierd.
Previous by thread: Format dates
Next by thread: Find and Replace Dialog Options
Index(es):
- Date
- Thread