Have field displaying time from a dattime field. Have been trying to figure out how [u]not</u> to show the seconds on time format.
Currently shows: 09:00:00 AM
Want to show: 09:00 AM

Any help would be appreciated.

Thanks

Mike

__________________
Mike

I guess you need to make use of FormatDateTime(Date,4) or something similar

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

or try this ... formatdatetime(now(),vbshortdate)

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Thanks for the input vadivel, but i need it to be in regular time and for it show AM/PM without the seconds only.

Mike

Assign the value of formatdatetime(now(), vbshortdate) to a variable .. lets say "TimeValue". Then make use of the following "if" loop to identify whether it is a AM or PM.

Dim strTemp

if DatePart("h", TimeValue) >= 12 then
 strTemp = "PM"
Else
 strTemp = "AM"
End if

Note: This is what struck me immediately after seeing your response. Just check out whether there are anyother better approach.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com