DateDiff and todays date?

[St.Phun]

Hi I was wondering if anyone knew if AccessXP has a today function which
would allow one to calculate the elapsed number of days between dateX and
today. Would the expression be DateDiff (Today) - (DateX)?
Thanx

 

[Rick B]

today is Date()

 

[fredg]

Hi I was wondering if anyone knew if AccessXP has a today function which
would allow one to calculate the elapsed number of days between dateX and
today. Would the expression be DateDiff (Today) - (DateX)?
Thanx

In days?
=DateDiff("d",[DateX],Date())
or..
=Date() - [DateX]

 

[John Vinson]

Hi I was wondering if anyone knew if AccessXP has a today function which
would allow one to calculate the elapsed number of days between dateX and
today. Would the expression be DateDiff (Today) - (DateX)?
Thanx

The DateDiff function takes three arguments: the unit of measurement
("s" is seconds, "yyyy" is years, "d" is days), and two date/time
fields. Try

DateDiff("d", [DateX], Date())


John W. Vinson[MVP]

 

[St.Phun]

Thanx I got it to work.
-St.Phun

Hi I was wondering if anyone knew if AccessXP has a today function which
would allow one to calculate the elapsed number of days between dateX and
today. Would the expression be DateDiff (Today) - (DateX)?
Thanx

The DateDiff function takes three arguments: the unit of measurement
("s" is seconds, "yyyy" is years, "d" is days), and two date/time
fields. Try

DateDiff("d", [DateX], Date())


John W. Vinson[MVP]