Change date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, first, I have a lot of questions and feel bad asking silly small Q?'s,
and I'm wondering if there are any books / websites recommended for locating
this type of information, such as the following question? (I am looking for
a solution to the question too!) :)

Question:

I have a date field that shows as 1/10/2006, or 6/26/2007, or 10/15/2006,
for instance. I need it to produce results like this: Jan 1, or Jun 26 or
Oct 15.

Thanks in advance!

-Valerie
 
format([fieldname], "mmm dd")

There are hundreds of books, just pick one. The Online Help file is
sometimes useful. Press F1.
 
So I'm assuming they are all good then? There is not one that's the holy
grail of them all? Fantastic, I'm hitting Border's this weekend!

Thanks S. Clark.

-Valerie



[MVP] S.Clark said:
format([fieldname], "mmm dd")

There are hundreds of books, just pick one. The Online Help file is
sometimes useful. Press F1.

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

Valerie said:
Hello, first, I have a lot of questions and feel bad asking silly small
Q?'s,
and I'm wondering if there are any books / websites recommended for
locating
this type of information, such as the following question? (I am looking
for
a solution to the question too!) :)

Question:

I have a date field that shows as 1/10/2006, or 6/26/2007, or 10/15/2006,
for instance. I need it to produce results like this: Jan 1, or Jun 26
or
Oct 15.

Thanks in advance!

-Valerie
Click to expand...
Click to expand...
 
Hi, Valerie,

Any good bookseller will have plenty of good books on using Access. You might
start by looking at bn.com (Barnes & Noble). If you like publishers, as
opposed to booksellers, Que, Sybex, Wrox, Microsoft Press, and probably a
half-dozen others publish such books.

Re your question: use the Format() function, e.g. Format(DateFieldName, "mmm
d") AS TextFieldName (in your SQL statement. This function can also be used
in VBA.

Hope this helps,

Sam
 
Dear Valerie:

Not all books will be written to the level of expertise of every reader.
Not all books will be covering the specific areas where you need assistance.
It may take some hours to review them and choose. But this is definitely
the way I do it.

All good? No, but 95% of them are. I grabbed one by title only and it was
of no use to me. I probably just didn't click with the author and his
chosen subjects. But with moderate care, you can almost certainly avoid
this.

Tom Ellison


Valerie said:
So I'm assuming they are all good then? There is not one that's the holy
grail of them all? Fantastic, I'm hitting Border's this weekend!

Thanks S. Clark.

-Valerie



[MVP] S.Clark said:
format([fieldname], "mmm dd")

There are hundreds of books, just pick one. The Online Help file is
sometimes useful. Press F1.

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

Valerie said:
Hello, first, I have a lot of questions and feel bad asking silly small
Q?'s,
and I'm wondering if there are any books / websites recommended for
locating
this type of information, such as the following question? (I am
looking
for
a solution to the question too!) :)

Question:

I have a date field that shows as 1/10/2006, or 6/26/2007, or
10/15/2006,
for instance. I need it to produce results like this: Jan 1, or Jun
26
or
Oct 15.

Thanks in advance!

-Valerie
Click to expand...
Click to expand...
Click to expand...
 
The original requester said:
"I need it to produce results like this: Jan 1, or Jun 26 or Oct 15."

You'd need to use
format([fieldname], "mmm d")
if you want days 1 to 9 to appear as single digits and not with a
preceding zero.
 
Back
Top