todaysdatetime = FormatDateTime(Now)
If InstrRev(todaysdatetime, "AM") then
todaysdatetime = replace(todaysdatetime, "AM", "am")
ElseIf InstrRev(todaysdatetime, "PM") then
todaysdatetime = replace(todaysdatetime, "PM", "pm")
Else
'Nothing
End If
--
Regards
Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk
Keeping it FREE!
Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
John Berman <Jo*********@blueyonder.co.uk> wrote in message
news:qI**************@news-binary.blueyonder.co.uk...
Hi
I use:
todaysdatetime = FormatDateTime(Now)
to feed the date time into a variable and I get as expected something like
this:
2/28/2004 11:51:07 AM
but what I want it the am / pm markers in lower case like
2/28/2004 11:51:07 am
Would this be easy to achive ?
Regards
John Berman
jo*********@blueyonder.co.uk