Extracting Medium Time from General Date 1

[annie52]

I have a Date/Time field with a General Date (6/19/2007 5:34:23 PM) called MilTxnDate.

I am able to extract the Short Date (6/19/2007) by using DateValue([MilTxnDate]) but can't figure out how to extract the Medium Time (5:34 PM). I do not want the seconds.

 

[PHV]

What about this ?
Format(MilTxnDate,"h:nn AM/PM")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[annie52]

Excellent! PH, you've always been my hero. Thanks!!!