Forums

form block with date time field issue

Permalink
Hi,

I've used a form block on my site with the answer type of Date time field is selected. However, it comes up the form result with the date and time always shows "1970-01-01" in the CS5 back end as attached file "dateNTime". No matter the user had selected the date other than "1970-01-01".
I've checked any possibility might cause this issue. I've fond the submit page property with the Public Date/Time is set as "1970-01-01" as attached file "pageProperties"
However, I couldn't think what the relevance between them. I've been searching on the forum to find the solutions with no luck.
Does anyone have the same issue? It would be very appreciated if you could let me know how to fix it. Thanks in advance.

2 Attachments

 
cherrycake replied on at Permalink Reply
cherrycake
the date/time is stored as a unix timestamp which is the number of seconds that has elapsed since 1970 jan 1 which is why you see that date. this means the date isn't saved i.e. it's saved in the database as 0 for some reason.

can't think of any obvious reason why the built in functionality isn't working. it sounds like the value isn't getting posted when submitting.
amazeDesign replied on at Permalink Reply
Thanks very much for your reply.
Somehow the date is working on the form result in C5 back end as attached file "dateWorks". But mostly not working.
I'm wondering if you know where the file of this form result is stored.