Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
Feb 27, 2022
Solved

Calculated Dates (taking into Account Holidays)

Hello Experts,   I am building a table: tblDatesDeliver. There are 5 fields in this table.  2 are manually entered 3 should be calculated based on the number of business days count prior   I h...
access
  • arnel_gp's avatar
    arnel_gp
    Mar 11, 2022

    Tony2021 

    im too lazy to follow the thread.

    but i get the idea based on the worksheet to attached.

    see your demo.

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Mar 11, 2022
No, the date is November 3, 2022. Not March.
arnel_gp's avatar
arnel_gp
Iron Contributor
Mar 11, 2022
on the worksheet is March.
coincidence? today's date?
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Mar 11, 2022
    Yes, it is.
    • Tony2021's avatar
      Tony2021
      Iron Contributor
      Mar 11, 2022
      sorry I am tardy.
      Hi Arnel.
      George: In Arnel's sample db, I think it is correct. The reason it returns 10/27 and not 10/26 is because there is actually not a Halloween holiday in the table but if it is entered in teh holiday tbl then the date changes from 10/27 to 10/26 (I tested this).

      Arnel I tested and its perfect! Thats amazing. I can also apply that logic elsewhere and change the count in the code. I have many other day count requirements. Was only a simple example I posted initially.

      thanks again guys. Very kind and grateful for the assistance. Enjoy the weekend!
      • arnel_gp's avatar
        arnel_gp
        Iron Contributor
        Mar 11, 2022
        goodluck!

Resources