Help with extracting time from date field inquery

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

How would extract the hours and minutes from a datetime field of a table.
I've tries DatePart("h",<date field name>) and nothing for the minute value.
Any ideas. I using Access xp
 
Fred,

If it's for display/presentation purposes only...
Format([YourDateField],"hh:nn")
If you want to actually return the time value only...
[YourDateField]-Int([YourDateField])

- Steve Schapel, Microsoft Access MVP
 
Back
Top