More Probs with Dates and Times

[julietbrown]

Access Help + Books don't give full spec of the DatePart function. I've got as far as getting out the day, the month, the year, the hours, and the seconds, but I can't get out the MINUTES. I've tried to guess the relevant parameter, but of course it thinks "m" is month, and it won't accept any of my other guesses for "mins"/"min"/"mm" ... etc.

What is the string I need? Then I will be able to write lots of code to deal with absolute and elapsed times, which 'basic Access' obviously can't deal with. (If you try to subtract a start time from a finish time you get a whole date ... in the 19th century!)

(Moderator: help me, I've never posted to a forum before today ... should this be a 'reply' to my own previous message? Also, I promise I have consulted 'Help' and several books to no avail!)

 

[pbaldy]

Try "n"; they used that since m was used for month.

 

[julietbrown]

Thanks - and

Thanks to person who first replied ... "n" works, and I would never have guessed it in a million years.

I don't suppose you know any more neat tricks, like how to get the hours/mins/secs that have elapsed between two dates, without writing loads of code (which is "fun" but takes a lot of time!)