DATEDIFF

  • Thread starter Thread starter RON
  • Start date Start date
R

RON

How do I create (in Access) a field that yields today
minus dates in the past so that whenever I open the
database I get the result of today minus some date in the
past which result obviously will increase by 1 as each day
goes by. Each record will have a different date in the
past for the calculation. (I want to use the date that
appears in another column (field) that I already have set
up entitled interestdate which contains the relevant date
in the past for that particular record.
 
How do I create (in Access) a field that yields today
minus dates in the past so that whenever I open the
database I get the result of today minus some date in the
past which result obviously will increase by 1 as each day
goes by. Each record will have a different date in the
past for the calculation. (I want to use the date that
appears in another column (field) that I already have set
up entitled interestdate which contains the relevant date
in the past for that particular record.
Click to expand...

Set the control source of an unbound control to:
=DateDiff("d",[InterestDate],Date())
 
Back
Top