date format in expression

S

smk2

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
 
K

Ken Snell

You need to put the actual format inside " characters:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countdown macro - display settings 2
Time format hh:nn drops leading zero 0
Elapsed time using date and time fields 4
Converting Text to date format and filter 7
Date Comparisons 4
Computing Elapsed Time 4
A03- Date format in tables? 1
SQL date and milliseconds 7

Top