IIf help

J

jimmy.kirk

Interval: Format([Date],"hh") & ":" &
IIf(Int(Format([Date],"m"))<29,"00","30")

For some reason, it always evaluates the same.

If I echo out 'Format([Date],"m")', it appears to show a number. I
tried adding the int() to make sure it was read as a number, but to no
avail. Any help?
 
D

Duane Hookom

I think you are assuming that M is Minutes while M is actually Month. For
minutes, use N.
 
Top