HELP - time display format

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

Guest

I am trying to make a report design easier by concatenating 2 dates separated
by a hyphen rather than having 3 separate controls, but I cannot get the
times to display as hh:mm rather than hh:mm:ss even tho' singly they are
perfect. If there is a way to set up the expression with the specific format
in the underlying query I can't find that either. It's driving me insane!!!!
 
I think you are trying do put something like this in the Control Source of
your text box:
=Format([Date1], "mm\/dd\/yyyy h\:nn ampm") & " - " &
Format([Date2], "mm\/dd\/yyyy h\:nn ampm")
 
Back
Top