date format in expression

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

Guest

I am trying to format the date to show just hour and minute
The following statement contains a syntax error

=IIf([ApptTypeID]=3,"Time: " & Format([ApptStart], hh:nn) ,"LS: " & [LSTime]

It previously read
=IIf([ApptTypeID]=3,"Time: " & [ApptStart],"LS: " & [LSTime]

and syntax is fine. I didn't like the time showing the milliseconds
What am I missing
Thanks so muc
Sally
 
You need to put the actual format inside " characters:

=IIf([ApptTypeID]=3,"Time: " & Format([ApptStart], "hh:nn") ,"LS: " &
[LSTime])
 
Back
Top