Tigra Calendar Product Family - Tigra Calendar Product


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

Not logged in [ Login | Register ]

SoftComplex Forums » Tigra Calendar Product Family » Tigra Calendar Product » Calendar Dates

Last active: Never

Printable Version | Subscribe | Add to Favourites

chrisb

Newbie

Posts: 1
Registered: 6/28/2006
Member Is Offline

posted on 6/28/2006 at 08:25 AM

Calendar Dates

Hi,

When I select a date from my Calendar it saves it in the format 06/15/2006 IE MM/DD/YYYY.

But I have my calendar on a form, which saves this data in a mysql database. Now in the field for the calendar I have the type specified as the type date.

However when I submit the date it saves it as 00/00/0000? Yet if I change the type to Varchar it does save the data? Any idea why the type date did not work?

tigra

Administrator

Posts: 1912
Registered: 6/17/2002
Location: US, CO
Member Is Offline

posted on 6/28/2006 at 11:54 AM

I guess you're talking about the storing the date in the database. It is your responsibility to validate and convert the date received from the client (form submission) before posting the value in the database. Obviously your database doesn't like MM/DD/YYYY format, but if this is the format users of the application like then you're stuck with it and you need to write the code that will reformat it on the server side.