Search results

THANK YOU Arnel this is SOVLED. :D:D

@isladogs Can you tell me why I have to use this ConfrMemo_Due_Date: SubtractWeekdays([Visit Start],10) in the query and not this ConfrMemo_Due_Date: SubtractWeekdays([Visit Start],-10)? and what do i need to do properly say thank you here?:)

@isladogs No :) everything is perfect! the 1st is the holiday, so it selects 31st, the output is 10 business days before start date.

Can you PLEASE tell me why I have to use this ConfrMemo_Due_Date: SubtractWeekdays([Visit Start],10) in the query and not this ConfrMemo_Due_Date: SubtractWeekdays([Visit Start],-10) THANK YOU! THANK YOU! THANK YOU!

wait! WAIT! it works. I removed - from -10 and it works!! look! Visit Start Visit End ConfrMemo_Due_Date 1/15/2019 1/16/2019 12/31/2018 1/22/2019 1/24/2019 1/8/2019 1/14/2019 1/17/2019 12/28/2018 1/29/2019 1/31/2019 1/15/2019 1/16/2019 1/17/2019 1/2/2019 1/15/2019 1/16/2019 12/31/2018 1/15/2019...

Thank you for trying to help Arnel. It doesn't work the same way. See the output. Visit Start Visit End ConfrMemo_Due_Date 1/15/2019 1/16/2019 1/14/2019 1/22/2019 1/24/2019 1/21/2019 1/14/2019 1/17/2019 1/14/2019 1/29/2019 1/31/2019 1/28/2019 1/16/2019 1/17/2019 1/15/2019 1/15/2019 1/16/2019...

here is the holiday table. ID Name varchar HolidayDate Weekday varchar 1 New Year’s Day 1/2/2017 Monday 2 President’s Day 2/20/2017 Monday 3 Spring Holiday 4/14/2017 Friday 4 Memorial Day 5/29/2017 Monday 5 Independence Day 7/4/2017 Tuesday 6 Labor Day 9/4/2017 Monday 7 Thanksgiving 11/23/2017...

@isladogs My comments are in bold 2b) As 26 Dec isn't a holiday in the US, then I think you meant the due date should be 26 Dec 2018 (not 26 Jan 2019) from a start date of 8 Jan. Correct? Really not sure what you meant by "In the scenario 01JAN2018, the due date will be 26JAN2019" That’s...

@isladogs Ok. Let’s see. My comments are in bold 1. Please explain the concept of having an END DATE 10 working days BEFORE a START DATE START DATE is always at least a months in the future form now. A team member enters a START DATE into the Dd and the date generates several deliverables...

hi Arney, it doesn't work. subtracting one day only. The query is calling for -10.

Listen, i am not trying to be disrespectful. you are losing me with so many questions. I told you I am not a programmer and I was trying to get your focus only on the problem that doesn't work. it's my form of efficiency, since I am occupying your time. Can we try again? I really do need help...

can addition and subtraction be in the same code? maybe it should be separate module?

my mistake. the START DATE should have been 15JAN2018. All of my start dates are about one month+ into the future. does this help with confusion?

I need to have both, adding and subtracting. Everything works fine with the adding part. It works like this; the START DATE is entered in to the main table via form. This date generates deliverable dates (END DATES) after the START DATE and one deliverable date 10 business days prior to START...

Thank you, isladogs. What other detail can i add to make it clear?

Good morning/afternoon, I have a module that calculates future dates from a start date and I need to figure out how to add subtraction part to it. So, the same idea, start date minus 10 business days (calling is in a query), if falls on a holiday, then the next business day is the DATE. I tried...