Forum Discussion
Solved
Issue with substracting date (date.adddays)
Hello, I have an issue: I have a column (Test) whcih has either a "0" or a "1" in as a check column. Now I want to add a new costum column which should have a corrected date in, I tried now sever...
this
=if [Test]="1" then (Date.AddDays[ar_Date.1],-1) else [ar_Date.1]
should be in this way "(" moved just before [ar_Date.1]
=if [Test]="1" then Date.AddDays([ar_Date.1],-1) else [ar_Date.1]
may be you could get other errors, but try
Thanks to both of you - had to use both ways to fix it (checked for error with the 2 step approach) and the applied the corrected formula. You made my day 🙂