jmarinis
|
| Posted: 07/18/2002, 3:51 PM |
|
It seems like there needs to be a DBFormat property for links created from dates. I'm using PHP with mySQL and I think I've tried pretty much everything to format the text of a date being retrieved from a field in the database. I kept getting different forms for 12/31/69 (the date version of 0 i believe). As soon as I changed it to a text label and set the dbformat, the date was fine. I realize that it could be done with code, but since I'm not manipulating the date in any way, I think I should be able to get the date formmatted correctly without doing so.
Am I right or am I ignorant?
|
|
|
 |
Nicole
|
| Posted: 07/22/2002, 5:08 AM |
|
Hello,
some explanation first.
If you use PHP you should specify the DB
"Date format" property in Connection/Server tab.
This format is required because type of datefields is timestamp,
this info is required for timestamps to work properly.
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.
AS Link field doesn't have DBFormat property the workaround is to change field type to Link, define DV and display date format, reverse back to link and it will work.
|
|
|
|
jmarinis
|
| Posted: 07/22/2002, 2:42 PM |
|
Thanks, that work around did the trick.
|
|
|
|
|
