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?
 
Back
Top