C CMM Dec 18, 2007 #1 How do I change the date format of yyyymmdd so a query will identify weekend dates as a criteria? Thanks.
How do I change the date format of yyyymmdd so a query will identify weekend dates as a criteria? Thanks.
K KARL DEWEY Dec 18, 2007 #2 If your field is a true DateTime then use --- Format([YourDateField],"w") with criteria of 7 or 1 for Saturday and Sunday.
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 Dec 18, 2007 #3 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
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
