Querry by date

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

Douglas J. Steele

Not quite sure what you're looking for.

By Day of the day, do you mean you want to know that today (2003/06/29) is
the 29th, or do you want to know that it's a Sunday? And if you want to know
that it's a Sunday, do you want that as text, or do you want to know that
it's day 1 of the week?

If the first, you want Day(Date()) to get 29

If the second, you want Format$(Date(), "dddd") to get Sunday, or
Format$(Date(), "ddd") to get Sun

If the third, you want Weekday(Date()) to get 1 (vbSunday)

If you're looking for something different, post back with more details.
 
Erik,
Please check the System Date and Time on your computer. When you place a
"future" date (7/5/03) on your post, it displays at the top of the NG for
days. A real NG no-no!
 
I wish to run a query by > Date (Day of the day)
I can do it with writing in date of the day.
Are there possibility to do it automatically in a query?
If it is can someone tell me how to do it?

Thanks
Erik Gjertsen.
 
Back
Top