DateDiff calculation in a query

[jac_pol]

Hi all

I'm using MS Access 2000 and I'm trying to calculate a date diff field down to the minute rather than the hour. At the moment I'm using the following code in the query, Variance: DateDiff("h",[ACTUAL_ARR_TIME],[PLANNED_ARR_TIME]). The format of the table is 19/06/2004 01:25:00

I would be eternally greatful for any help

 

[SydneyGeek]

Try:
Variance: DateDiff("mm",[ACTUAL_ARR_TIME],[PLANNED_ARR_TIME]).

Denis

 

[jac_pol]

Thanks for the input Dennis, it didn't work, I get #ERROR showing up. I've tried all manner of combinations, "d" is days, "m" is months, "y' is years, "h" is hours and "s" is seconds. so what I worked out was to calculate the variance in seconds (EG Variance: DateDiff("s",[ACTUAL_ARR_TIME],[PLANNED_ARR_TIME]), then I created new field which divided the variance by 60 which gave me the minutes. (Minutes Late: ([Variance]/60))

Thanks again for your input.

regards
Jack Pol

 

[Norie]

Use "n" for minutes.

From help

Setting	Description
yyyy	Year
q	Quarter
m	Month
y	Day of year
d	Day
w	Weekday
ww	Week
h	Hour
n	Minute
s	Second

 

[jac_pol]

Many thanks for that Norie, works a treat