Defaulting a "Medium Time" field to be "p.m." instead of "a.m."?
Hello all,
I assume this must be a pretty basic question but after a while searching I haven't found a solution.
I have a Date/Time field in my database with a "medium time" format. The problem that I have is that if you don't specify if the hour is in AM or PM it defaults it to AM. I'd like to have the opposite behaviour.. that when I write "5.30" it stores it as "5.30 pm" except if I explicitly input "5.30 am".
Thanks a lot for helping.
Cheers!
Hello all,
I assume this must be a pretty basic question but after a while searching I haven't found a solution.
I have a Date/Time field in my database with a "medium time" format. The problem that I have is that if you don't specify if the hour is in AM or PM it defaults it to AM. I'd like to have the opposite behaviour.. that when I write "5.30" it stores it as "5.30 pm" except if I explicitly input "5.30 am".
Thanks a lot for helping.
Cheers!