Forum Discussion
Date.AddDays not working with negative numbers
re:"You can see from the following table that when I use positive numbers I get the correct output, and when I use negative I just get today's date (CourseExpiry_Completion_Date1 and CourseExpiry_Completion_Date2):"
When I look at some of your dates in your screen shot:
and I put these data into a plain sheet and do the subtraction there I get:
That means the subtractions are correct.
So have a look at how the values in column ~.DaysUntilExpiry are calculated!
This is my code:
My [Effective_End] column data type is Date:
My days column (CourseExpiry_negative) is a number:
I've tried changing the days column to text and then replacing all the minus characters. I've also tried changing the data type of the Effective_End and days (CourseExpiry_negative) columns to Text and then using Date.From and Text.From in my Date.AddDays formula and it still doesn't work.