I created a custom date field and imported data. The date is in the field, but when I try to edit the records, the date shows 1/1/70 in the date picker field and if I modify it it send a serial date to the database. Can we only use serial dates? What am I missing or doing wrong with this custom date. I'm also importing the post date with the same formatting and it works fine. Any help appreciated.
Dear Glynn,
Dates are kept as timestamps in the DB. You can modify the import script and run strtotime() on the date to get a timestamp.
Please let me know if there is anything else that I can assist you with.
Regards.
Caridad
If I simply enter a manual entry into the custom form field and use 05/17/1986 as the date from the date picker it saves 516672000 in the database field. The form also saves nothing to the database if I put in a date prior to 1/1/1900 from the date picker.
Dear Glynn,
This is a limitation of the timestamp format. The number is how many seconds since 1/1/1970
Please let me know if there is anything else that I can assist you with.
Regards.
Caridad