Short Time Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 97. The report footer has the following field inserted by
using the default "Insert Date/Time" option. It is using short time format.

=Format(Date(),"Long Date") & " " & Format(Time(),"Short Time")

My question is: What does Access do with the seconds? Does it just drop
them or does it uses a rounding algorithm?

Thanks
 
LeAnn said:
I am using Access 97. The report footer has the following field
inserted by using the default "Insert Date/Time" option. It is using
short time format.

=Format(Date(),"Long Date") & " " & Format(Time(),"Short Time")

My question is: What does Access do with the seconds? Does it just
drop them or does it uses a rounding algorithm?

Thanks
Click to expand...

Testing in the immediate window indicates that seconds are truncated, not
rounded.

?Format(#5-16-2005 13:15:59#, "short time")
13:15
 
Thanks Rick. And thanks for the "hint" about the immediate window. I
should have thought of that. :)
 
Back
Top