IIf help

  • Thread starter Thread starter jimmy.kirk
  • Start date Start date
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?
 
I think you are assuming that M is Minutes while M is actually Month. For
minutes, use N.
 
Back
Top