garycrunk
Posts: 23
|
| Posted: 05/08/2007, 5:22 PM |
|
I have a bit of a 'format' issue when it comes to Date Formats....
In MySql, it allows me to set up dates in the format of:
DATE YYYY-MM-DD
DATETIME YYYY-MM-DD HH:MM:SS
Codecharge allows me to setup the Date format as:
dd/mm/yyyy
mm/dd/yyyy
I've tried telling EITHER Codecharge Studio OR Mysql to layout the Date format the same way...
But it will not work either way....
Does Anyone know how I can seup either my MySql database or Codecharge so that the Dates Entered will match and work. When entering dates, it doesnt store it in the database because it's in the wrong format.
I've tried telling codecharge to use yyyy-mm-dd. and when I set up codecharge to auto-date the field, it works on the screen, but it does NOT go into the database....
Any Clues????? Thank you in advance
_________________
Gary Crunk
Job Examiner |
 |
 |
Benjamin Krajmalnik
|
| Posted: 05/08/2007, 5:26 PM |
|
You are confusing 2 items.
One is the format used by the DAL to access the database (set in the Server
connection properties), and another is the display format.
So, in short, you set the Date Fromat of the connection, Server tab, to that
used by MySQL, and you specify the display format which you want either at
the control level or at the Project level (which is the default if not
format is given at the control level).
|
|
|
|
garycrunk
Posts: 23
|
| Posted: 05/09/2007, 9:20 AM |
|
Thank you. However, It's still not working. Here is what's happening.
1) I have Codecharge set up in it's defaults for date format: yyyy-mm-dd hh:nn AM/PM
2) This is the same format that I've set up the field in the MySql Database
When I create a form to ADD a Record, it 'displays' the proper date in the Text Box ...
However, upon insertion of the record, it does NOT record the DateTime field... When you examine the database, all other fields are entered, but the date/time field is 0000-00-00 00:00 AM
So this is telling me that ASP is not placing that data in the date field even though it is showing up in the Data-Entry form in the proper format...
_________________
Gary Crunk
Job Examiner |
|
|
|
Benjamin Krajmalnik
|
| Posted: 05/09/2007, 9:39 AM |
|
Check to make sure that the entry control is defined to contain a date
field, and not a string.
|
|
|
|
|
