changing time in fired to 24 hr clock 1

[mattl72]

I have a form with field that is set to the current time (using the time() function) when the user enters data. It is storing it using 12 hr time (ie 1:30 PM) - I need to store it as 24 hr time. I have tried setting the format property to short time and using the format function in code [format(time, "HH:mm&quot] and it still goes back to 12 hr clock. Any help would be greatly appreciated.

Thanks
Matt L
Direct One Networking

 

[chrissie1]

i think you need to set the regional settings of windows
because in table view it will display it in this fashion, just display Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

 

[mattl72]

Thanks for your quick response

I really need to do it without changing the regional settings. The users want the clock on their desktop to display 12 hr time.

Thanks,
Matt

 

[Newposter]

Nope,
Set the field to Date/Time, short format, and set the Default Value to =Now(). This will cause it to save the current time in 24-hr format. Newposter
"Good judgment comes from experience. Experience comes from bad judgment."