Access DatePart or DateAdd or Both?
Posted on 2011-03-12
We have in a table a "Created" date. We want to return a date reflecting only the previous workday. Meaning, if the date fell on a Sunday, we only want to see the results of the Friday's date. Therefore, whenever we run this query, it will reflect dates from only the weekday.
A couple things to note: We have it configured to a long date (showing the date, hour, and minutes). We have to have this long date feature for other reasons.
When we use the DateAdd or DatePart feature, we seem to get results in the year 1899 or 1900. What are we doing wrong?
This feature is needed so we can run reports daily to reflect the previous work day's productivity.