Tigra Calendar Product Family - time format is losing AM/PM


	\| About Us \| Services \| Download \| Order \| Support \| \|

Not logged in [ Login | Register ]

SoftComplex Forums » Tigra Calendar Product Family » time format is losing AM/PM

Last active: Never

Printable Version | Subscribe | Add to Favourites

middletree

Junior Member

Posts: 3
Registered: 7/26/2005
Location: Arlington, TX
Member Is Offline

posted on 7/26/2005 at 08:23 PM

time format is losing AM/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:||www.middletree.net/calendar/T16200.htm 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

Junior Member

Posts: 3
Registered: 7/26/2005
Location: Arlington, TX
Member Is Offline

posted on 7/26/2005 at 09:31 PM

Never mind

I wrote a VBScript function to deal with it.

middletree

Junior Member

Posts: 3
Registered: 7/26/2005
Location: Arlington, TX
Member Is Offline

posted on 7/27/2005 at 02:03 PM

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