Hello everyone

I need to write some code to return the date of the last working day (Fri) of the current week. This is so I can run a query to select very specific data from my base. Is there a built in function or can anyone tell me a way of doing this. Thanks in advance.

The Friday that ends this week:
=Date() - Weekday(Date(), 7) + 7

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Russell Lucas" <(E-Mail Removed)> wrote in message
news19B833D-726A-4CB3-80B4-(E-Mail Removed)...
>
> I need to write some code to return the date of the last working day (Fri)
of the current week. This is so I can run a query to select very specific
data from my base. Is there a built in function or can anyone tell me a way
of doing this. Thanks in advance.