Calculating Remaining Days

  • Thread starter Thread starter Simon Dowse
  • Start date Start date
S

Simon Dowse

Hi,

Any ideas how I can have something in a databast the
calculates the remaining days between one control and
todays date. I have a field that is called 'Target
Resolution Date' and I want to know how many days are left
between this date and today.

Many thanks in advance.
 
How about trying the DateDiff() function? It would go something like the
following in your query:

RemainingDays: DateDiff("d", Date(), [Target Resolution Date])


hth,
 
That seemed to work, but not really udnerstanding how it
works I ask for some more assistance. This is coming up
with a negative figure, any ideas on how to turn this into
a positive figure?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Message box with days of month & date. 1
Excel Excel Show Countdown Date 7
Excel High lightng dates in future, today and past 1
calculate day from date 3
Complex query 0
Help please with nested iif 2
How do you subtract two dates in an expression? 3
Counting calendar Days - not including Sundays 3

Back
Top