skyrun
Active Member
posted to an existing report of this that was on the community forum, putting here so you can see it on the professional forum.
of my new new form rows are timestamped 00:00:00 now. the date works, but the time is always 00:00:00. just started happening recently post-1/3/19 at least.
i am using a 'hidden' date element (not timestamp element type) with Default to current date = Yes and Always return current date. = No. note in case it matters for debugging that i also use 'local time' for all of my date/times (NOT UTC).
***looking at another forum item, when i put in h:i:s on the form format, it puts in 12:00:00 so 12pm vs. the default H:i:s which puts in 00:00:00. so changing H to h does do something if that's a clue.
I tried setting the default in the db to CURRENT_TIMESTAMP and fabrik is overriding it and storing with 00:00:00 or 12:00:00. (tried advanced formats = yes also on the advanced tab).
The 'workaround' i found is to select Always return current date. = Yes. when i set it this way, the time works correctly on both new and edit.
But i would like to be able to set Default to current date = Yes and Always return current date. = No to record when the row was created (not edited) and that has stopped working as far as the TIME goes.
of my new new form rows are timestamped 00:00:00 now. the date works, but the time is always 00:00:00. just started happening recently post-1/3/19 at least.
i am using a 'hidden' date element (not timestamp element type) with Default to current date = Yes and Always return current date. = No. note in case it matters for debugging that i also use 'local time' for all of my date/times (NOT UTC).
***looking at another forum item, when i put in h:i:s on the form format, it puts in 12:00:00 so 12pm vs. the default H:i:s which puts in 00:00:00. so changing H to h does do something if that's a clue.
I tried setting the default in the db to CURRENT_TIMESTAMP and fabrik is overriding it and storing with 00:00:00 or 12:00:00. (tried advanced formats = yes also on the advanced tab).
The 'workaround' i found is to select Always return current date. = Yes. when i set it this way, the time works correctly on both new and edit.
But i would like to be able to set Default to current date = Yes and Always return current date. = No to record when the row was created (not edited) and that has stopped working as far as the TIME goes.
Last edited: