Forum Discussion
Solved
DateAdd not working
Hi I am using the dateadd function to try and add 56 days to a date and it is working for some of the dates but not for others - i cant figure out why ?
Try this
Column ='Table'[Won Date]+56
Note: DATEADD() returns a table that contains a column of dates. The result table includes only dates that exist in the dates column.
Regards,
Nandu Krishna
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍
Proud to be a Super User!
Thanks nandukrishnavs
Simple as that really.
Can you please explain what you mean " DATEADD() returns a table that contains a column of dates. The result table includes only dates that exist in the dates column " ?
I am right in saying that if i add 56 days to a date and it comes back to say 31 Nov 2020 - as 31 Nov 2020 doesnt exist then i get a blank?
trying to understand where i went wrong and why i would ever use dateadd function
Sean-OReilly wrote:I am right in saying that if i add 56 days to a date and it comes back to say 31 Nov 2020 - as 31 Nov 2020 doesnt exist then i get a blank?
You are correct.