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!
Kerria1276 This is interesting.
Can you open the advanced editor and past in the full query code here (removing anything confidential with the source connection)
That might help us troubleshoot.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.