Software·43,781 discussions

Access Expression – DateDiff

Locked

I have the following expression in Access to count how many days passed from the last action date. I need to exclude weekends from this expression. Is there any way to do that?

=DateDiff(‘d’,[LastofAction_Date],Date())

Topic

Clarifications

In reply to Access Expression – DateDiff

Clarifications

Only by writing a function to ‘calculate’

In reply to Access Expression – DateDiff

the number of saturdays and sundays in the date range.

[Author]

Replies