working out the day

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

hi,

does anyone know the query formula that can work out the day from a
entered date.

cheers
fiona
 
The name of the day
Format(Date(), "ddd") or Format(Date(),"dddd")

The weekday number ---1 to 7 (Sunday to Saturday)
Weekday(Date())

The day of the month --- 1 to 31
Day(Date())

The day of the year --- 1 to 366
DatePart("y",Date())

By the way, DatePart can be used to get the Weekday number and the day
number of the month.
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

Dates 3
Getting the Year 1
working out the day from the date 2
display all 3
Create exprn that returns the highest value of 4 fields in a query 1
SUM PRODUCT 5
date calculation 5
Access Dateadd function question.. 0

Back
Top