add weekdays in query (1 Viewer)

Bumi66

New member
Local time
Today, 14:06
Joined
Jan 15, 2019
Messages
18
Hi Everyone, I'm new to this forum. I was looking for an answer but I couldn't find an easy way to solve my problem.
I have a query and I try to add days business days to a date e.g if its a Friday I need to add 3 days instead of 1.
Is there an easy way without VBA codes ? and if it's a VBA code where do i add it in the query ?
the field is called [Invoice date] and I need to calculate the arrival date at the customer what is usually 1 business day later.

Thanks in advance
 

Minty

AWF VIP
Local time
Today, 18:06
Joined
Jul 26, 2013
Messages
10,355
You will have to resort to some VBA, have a look at the thread linked at the bottom of this thread for some starters.

Do you also want to account for Holidays as well?

Welcome to AWF by the way!
 

JHB

Have been here a while
Local time
Today, 19:06
Joined
Jun 17, 2012
Messages
7,732
You can use the function WeekDay:
Look a the query in the attached database:
 

Attachments

  • NextDate.accdb
    464 KB · Views: 49

Bumi66

New member
Local time
Today, 14:06
Joined
Jan 15, 2019
Messages
18
Awesome JHB that was exactly what I was looking for.
Thank you very very much, You made my day :)
 

Bumi66

New member
Local time
Today, 14:06
Joined
Jan 15, 2019
Messages
18
Minty, I can't open that link

To view links or images in signatures your post count must be 10 or greater. You currently have 1 posts.
 

Users who are viewing this thread

Top Bottom