using the date in the calculation

[mattyj]

first of thank you everyone that has been helping me today, so far i have managed to get everything to work and i am now using the stuff you taught me to do other things now!

I am working on a calculation that will take 1 date and todays date and give me the number of days left.

e.g.(days)

660

300

5

0

[mr_vodka]

Well depending on what you mean by days left Today - yourDate or YourDate - Today.

Get ( CurrentDate ) - YourDate

number result.

reverse for the latter.