eguven
|
| Posted: 08/05/2002, 1:48 AM |
|
im trying to understand example in tutorial.in the tasks table there are two fields date assign,date resolve... im adding or trying to edit a task and i get this :
The value in field Date Assign is not valid. Use the following format: GeneralDate
The value in field Date Resolve is not valid. Use the following format: GeneralDate
messages...
in properties window i changed the date format,the fields type date to varchar but im still getting this message
please hlp,thanks
|
|
|
 |
Nicole
|
| Posted: 08/06/2002, 4:47 AM |
|
Eguven,
please check you have define the following settings which let you display and update date type fields correctly:
1. set Display date format in Site Properties (as I see it is already done and date format is set to "General Date" - m/dd/yy, HH:nn:ss AM/PM)
2. select proper db date format in the server side connection settings. E.g. mm/dd/yy
Then you should enter date in General format and it will be converted into db date format before inserting to the table.
|
|
|
|
eguven
|
| Posted: 08/07/2002, 12:38 AM |
|
im using MySql as database server, when i set the field type as DATE, 0000/00/00 format is coming, i think this is the problen because,i change db date from server side settings, thanks a lot...
|
|
|
|
|
