Date Formula

NAVBasic
NAVBasic Member Posts: 8
in NAV/Navision Classic Client
HI,
Is there any simple code to get the 3rd Monday of the month?

Answers

  • Developer101
    Developer101 Member Posts: 569
    edited 2021-05-23
    Simplest formula would be CALCDATE('WD1+2W',Date)

    For example: CALCDATE(''WD1+2W',01052021D) would return 17/05/2021 which first day of the week.
    United Kingdom

Categories