Date difference

May I know how to do a date different between a given date in a field and
today's date.

I want to add a field on aging and calculate the date difference in query.

For example : Aging = diff( transaction date, today date)

Thanks

--
Message posted via http://www.accessmonster.com

hi Emily,

EMILYTAN via AccessMonster.com wrote:
May I know how to do a date different between a given date in a field and
today's date.
If your result should be a date:

= CDate(dtToday - dtTransaction)

otherwise take a look at DateDiff() in the online help.


mfG
-- stefan --

I mean in a query table?
What should I add in?
Stefan Hoffmann wrote:
hi Emily,

May I know how to do a date different between a given date in a field and
today's date.
If your result should be a date:

= CDate(dtToday - dtTransaction)

otherwise take a look at DateDiff() in the online help.

mfG
-- stefan --

--
Message posted via http://www.accessmonster.com

On Jul 31, 9:53 am, Stefan Hoffmann
wrote:
May I know how to do a date different between a given date in a field and
today's date.

If your result should be a date:

= CDate(dtToday - dtTransaction)

That doesn't sound correct e.g.

SELECT CDate(DATE() - #2007-07-23 00:00:00#) AS result_datetime

returns a DATETIME value sometime around the turn of the last century :
(

otherwise take a look at DateDiff() in the online help.

Yes, I think the OP would want something more like:

SELECT DATEDIFF('D', #2007-07-23 00:00:00#, DATE()) AS result_days

Jamie.

--

hi Jamie,

Jamie Collins wrote:
If your result should be a date:
= CDate(dtToday - dtTransaction)
That doesn't sound correct e.g.
SELECT CDate(DATE() - #2007-07-23 00:00:00#) AS result_datetime
returns a DATETIME value sometime around the turn of the last century
Which is exactly the date span between the two dates based on the
default start date of the date type.
But I have to admit, that this is maybe not what she wanted.


mfG
-- stefan --