I have been looking for an easy way to to use the VBScript FormatDateTime function to get me a time like: 3:47 PM.
For whatever reason.. you can't do that! So try this:
Private Function sTime(dtime)
hr = hour(dtime)
mn = minute(dtime)
if hr > 12 then
hr = hr - 12
ampm = "PM"
ampm = "AM"
IF len(mn) = 1 then mn = 0 & mn
sTime = hr & ":" & mn & " " & ampm
The Result: -8:56 PM
NOTE: This is SERVER time, not client time!
Thanks for the suggestion Ellen!
Back | Tell A Friend | Search this Site
© 1998 - 2014 psacake.com
Send me One Million FREE Guaranteed Visitors