date formating

  • Thread starter Thread starter Haggr via AccessMonster.com
  • Start date Start date
01 is not numeric, however a formatted date like:

01/01/07

can be formatted as you desire:

Format(#01/01/07#, "mmm") for Jan

or:

Format(#01/01/07#, "mmmm") for January
 
that is the answer I was looking for, I got the "01" by formating the [date
field] Thanks, you guys are such a big help
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Count dates within a Month 4
Dlookup 7
Enter Date Format 9
Parameter Query grabs only Month and Year specifically 10
count by month 1
Combining Text and Date Vaules 4
Customised datatype for date 3
Enter dates in short form, but store them in Long Date format 2

Back
Top