Forum Discussion
Solved
How come the value is sometimes not calculated
I have a creation date and a delay. I'm calculating the due date by adding the delay to the creation date Date due = DATEADD([Date created];[Delay];DAY) in 80% of the cases it works fine but fo...
Hi osinquinvdm,
Please modify your formula as below, this will give all the due date as expected:
Date due = DATEADD(TableName[Date created].[Date],[Delay],DAY)
Best regards,
Yuliana Gu
Hi osinquinvdm,
Please modify your formula as below, this will give all the due date as expected:
Date due = DATEADD(TableName[Date created].[Date],[Delay],DAY)
Best regards,
Yuliana Gu
Nice Trick!
It does indeed work.
I wish DATEADD() was smart enough to force it like this on its own
Assuming the unit for [Delay] is a number of days, you could also write:
[Date created]+[Delay]
