count down date

[John thomas]

I have two fields date of order and fiting date
I want my query to count these dates down ,so i can see when a fitting date is getting close. I assume i write some sort of expresion but am not sure how to do this or weare to place it in my query

 

[boblarson]

DateDiff is the function you need.


DateDiff("d", "[Date of order]", "[Fitting Date]")