Support Forum Softcomplex logo
About Us  | Services  | Download  | Order  | Support  | |
| Search | Today's Posts | Stats | Board Rules | Not logged in [ Login | Register ]
go to bottom
Last active: Never

Printable Version | Subscribe | Add to Favourites   Post new thread
Author: Subject: Calendar Dates
chrisb
Newbie

Posts: 1
Registered: 6/28/2006
Member Is Offline
posted on 6/28/2006 at 08:25 AM Reply With Quote
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?
View User's Profile View All Posts By User U2U Member
tigra
Administrator

Posts: 2049
Registered: 6/17/2002
Location: US, CO
Member Is Offline
posted on 6/28/2006 at 11:54 AM Reply With Quote

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.
View User's Profile View All Posts By User U2U Member
Post new thread

Related Links:
Product Page
Product Demonstrations Live Demos
Free Download Free Download
Product Documentation Documentation
Support Forum Support Forum
 

Go To Top


Powered by XMB 1.9.1 Nexus
Developed By Aventure Media & The XMB Group © 2002-2004