Forum Discussion

Daniel_76's avatar
Daniel_76
New Member
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

     

    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

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

You can debug at your side.

First , add a column like 

if [Test]="1" then "success" else "fail"  .   If you have no errors and you get success and fail values, time to move on.

If not, find out where it's going wrong.

----------

Add another column like

Date.AddDays([ar_Date.1],-1).   Do you get a successful value? If so, move on by combining the above code with this.  If not, find out where it's going wrong.

 

 

Let me know how it goes