Skip to content

DD+1m = ?

Rodney JonesMember for 14 years 4 months
Created
4
3
0

Hi All,

 

How do I prove, or find out, what date is actually reported in the formula DD+1m?

 

Lets say my Data Date is 25th November 2021 00:00 will DD+1m return 25th December 2021 00:00 or will it count how many days in the month of November or December and return 30 days or 31 days later???

 

Thanks,

 

Rod

4 replies

Oldest first
  1. 0
    David Kelly ·

    Easy to check it out. Run a

    Easy to check it out. Run a global change and set a UDF to your formula!
  2. 0
    Rodel Marasigan ·

    Depends on where are you

    Depends on where are you using the formula. If using in Filter it calculates using the default calendar working days. If using on the report Page set-up option then it use the calendar days.

  3. 0
    Alexandre Faulx-Briole ·

    Hi Rod,if you want to use

    Hi Rod,

    if you want to use this formula in a lag between two activities, make sure to check the scheduling options: by default, the lag will use the predecessor's calendar, and yoy can choose the successor's, the default calendar or a 24h/d calendar

    Alexandre

  4. 0
    Zoltan Palffy ·

    to prove itfilterwhere Start

    to prove it

    filter

    where 

    Start equals DD+1m

    and then review your results 

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?