Date difference

[EMILYTAN via AccessMonster.com]

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

 

[Stefan Hoffmann]

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 <--

 

[EMILYTAN via AccessMonster.com]

I mean in a query table?
What should I add in?

hi Emily,

If your result should be a date:

= CDate(dtToday - dtTransaction)

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

mfG
--> stefan <--

 

[Jamie Collins]

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.

--

 

[Stefan Hoffmann]

hi Jamie,

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 <--