EMG
|
| Posted: 07/03/2002, 12:41 PM |
|
I have spent ~ 3 hours fiddling with CCS trying to get the date formating to work. Labels that are type text show the yyyy-mm-... php format, and when I change them to date type they will not show anything.
The db format is "m/d/yyy H:mm:ss a". I have tweaked every form and project setting imaginable and the damn thing will not work. Is this a mystery or am I stupid??
Anybody have any tips before I pull the plug and go shoot some bottle rockets?
|
|
|
 |
Alessandro
|
| Posted: 07/04/2002, 1:02 AM |
|
Try this:
$flddate_field=date("d.m.y H:i",strtotime("$flddate_field"));
to get date in dd.mm.yy hh:mm format,
but I'm not sure it'll work on Sql Server.
Date format seems to be a quite complex argument.
regards,
Alex
|
|
|
|
Nicole
|
| Posted: 07/05/2002, 5:20 AM |
|
Hello,
If you use PHP you should specify the
"Date format" property in Connection/Server tab that matches db date format.
This format is required because type of datefields is timestamp,
this info is required for timestamps to work properly.
Moreover on the forms you should select different DBFromat on the form for different type fields. Once form is created please check following settings on Data tab:
DataType: Date
Format (display format): select one you like
DBFormat: should match db date format. Select one from dropdown list or type it manually (in case there's no desired format in drop down ).
Note, that on record form you should enter dates in displaying format, then it will be converted to selected db format before inserting to db.
|
|
|
|
EMG
|
| Posted: 07/09/2002, 7:48 AM |
|
Nicole,
Much thanks, I finally got the date formats squared away. It really made my day!
Thanks.
|
|
|
|
|
