make a date a weekday (like 7/18/05 = Monday)

  • Thread starter Thread starter Mark Carlyle via AccessMonster.com
  • Start date Start date
M

Mark Carlyle via AccessMonster.com

How can I convert a number date to a word day?

I want to give 7/18/2005 and get back Monday
 
Mark

You can use the format function.

Format(#7/18/2005#,"dddd")

Ron W
 
Mark said:
How can I convert a number date to a word day?

I want to give 7/18/2005 and get back Monday
Click to expand...

Format([FieldName], "dddd")
or
Format(#7/18/2005#, "dddd")
 
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

Problem formatting dates from CSV file 2
Can some one modify the thirdfriday code to get me the following d 2
Weekly Date Calculation 9
convert date stamp to previous date 9
format date field 6
Date Fields on Form - Help?! 3
week numbers 3
Date criteria for autofilling date on a form 3

Back
Top