Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

DD+1m = ?

4 replies [Last post]
Rodney Jones
User offline. Last seen 5 days 9 hours ago. Offline
Joined: 17 Jun 2012
Posts: 44
Groups: None

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

Replies

Zoltan Palffy
User offline. Last seen 1 day 4 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3000
Groups: None

to prove it

filter

where 

Start equals DD+1m

and then review your results 

Alexandre Faulx-B...
User offline. Last seen 6 hours 37 min ago. Offline
Joined: 20 Jan 2003
Posts: 1352

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

Rodel Marasigan
User offline. Last seen 17 hours 3 min ago. Offline
Joined: 25 Oct 2006
Posts: 1654

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.

David Kelly
User offline. Last seen 5 weeks 2 days ago. Offline
Joined: 19 Oct 2004
Posts: 620
Easy to check it out. Run a global change and set a UDF to your formula!