Change Date Format

C

CMM

How do I change the date format of yyyymmdd so a query will identify weekend
dates as a criteria? Thanks.
 
K

KARL DEWEY

If your field is a true DateTime then use ---
Format([YourDateField],"w")
with criteria of 7 or 1 for Saturday and Sunday.
 
J

Jeff Boyce

Could you provide a little more description?

How does a "format" have anything to do with "weekend dates"?

Criteria for what?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

DateSerial and Criteria Limits 13
Append/Update Query 6
Convert Date 3
Convert Date 1
query from a form Date as number YYYYMMDD 6
Pass Calculated Parm to Query 2
Displaying data from the past six months 1
extract part of a text value into a date 2

Top