hour in a report

  • Thread starter Thread starter catherine
  • Start date Start date
C

catherine

I'd like to print the hour in a report
= Date() retunrs only the date but not the hour,
which formula should I use ?
Thanks
 
Catherine

The Now() function returns date and time. You can use the Hour() function
on Now() to return the "hour of the day", or you could simply Format() the
date/time string returned by Now() to display exactly what you're after.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top