Board Logo

time format is losing AM/PM
middletree - 7/26/2005 at 08:23 PM

I just discovered Tigra yesterday and love it so far. I am putting it into an Intranet app, and am having a problem. Because it's Intranet, you can't see the real page, but I put a static version at http:|| which will suffice.

Scroll down that page until you see a row of 4 textboxes with little Tigra calendar buttons. The first one is labeled "Temporary Solution Provided:".

When I have a blank field there, I open the calendar, select a date, and it stores the date and time in the format I like. This page uses ASP, which stores the date in a SQL Server database.

When I pull this page up and those 4 date fields already have data in them in the database, it prefills the text field upon page load. However, SQL Server has changed the time from 24-hours format to 12-hour format, complete with AM/PM.

Note that when you click the calendar button, it puts the time into the little text box, but shaves the PM off. Thus the time of 1:30 PM becomes 1:30, which is interpreted to mean 1:30 AM.

Any help would be appreciated, and I'll throw in that I have very little JS knowledge.

middletree - 7/26/2005 at 09:31 PM

Never mind

I wrote a VBScript function to deal with it.

middletree - 7/27/2005 at 02:03 PM

My solution didn't work. Any help on my original question will be appreciated.

Back to forum: