I'm trying to subtract 2 dates and return a number within a report
Basically days remaining between a date in the future and current date.
This is what I want as a result...I want to take a given date in the future say 28 August 2017 and have it give a result of the days remaining based on the current date. I have tried expressions in a table, a query, within the report and the best I have done is get the result to show as a date instead of a number ie....[DaysRemaining] - 3 among others, tried to format as an integer among others and none seem to work.
Any help is much appreciated
Hoop