Format Problem

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have a time field [SalesTime] that is formatted as medium time,
however; when i place it in an expression I get long time.

[SalesDate]&" "&[SalesTime]

returns 11/19/02 12:00:01PM

should be 11/19/02 12:00 PM

Any help apprciated.
Thanks
DS
 
= [SalesDate] + [SalesTime]
with a display format as desired.

Other option
=Format( [SalesDate], "mm/dd/yy ") & Format([SalesTime],"hh:nn AM")

Regards John
 
John said:
= [SalesDate] + [SalesTime]
with a display format as desired.

Other option
=Format( [SalesDate], "mm/dd/yy ") & Format([SalesTime],"hh:nn AM")

Regards John

I have a time field [SalesTime] that is formatted as medium time,
however; when i place it in an expression I get long time.

[SalesDate]&" "&[SalesTime]

returns 11/19/02 12:00:01PM

should be 11/19/02 12:00 PM

Any help apprciated.
Thanks
DS
Click to expand...
Click to expand...
Thanks John,
The second one worked with some tweaking.

=Format([SalesDate],"mm/dd/yy ") & " " & Format([SalesTime],"hh:nn AM/PM")
DS
 
Back
Top