Short Time Format

L

LeAnn

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
 
R

Rick Brandt

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
 
L

LeAnn

Thanks Rick. And thanks for the "hint" about the immediate window. I
should have thought of that. :)
 
Top