DateDiff

[castali]

DateDiff seems not working

SELECT DATEDIFF(Minute,Members.Deb,
Members.Fin) As Diff From Members

I want to get the number of minutes for each members between to columns Members.Deb and Members.Fin.. and it doesn't work

thank you

[castali]

I found the seconds in that way

SELECT DATEDIFF("s",Members.Deb,
Members.Fin) As Diff From Members

but if I use "m" or "minute" I get an error, how can I get the minutes ?

thank you

[YuckFou]

I have no MS Access so I can't serve but maybe for minute is "mi" , try it.
It works for MS SQL.

[castali]

I have tried it but it doesn't work ....

maybe there is a way to use a convert .. to get with seconds a format like
"Years : months : days : hours : minutes : seconds"
?

thank you

[YuckFou]

I have looked for datediff in VBA help and there is "n" fo minutes. Mayby it'll solve your task .
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second

[castali]

perfect ! I was looking for it .....

it works

thanks a ton