I have followed the instructions in this thread, and the "timestamp" version discussed works great. However, I cannot get the "date" version working. I need the "date" version for date prior to 1970. (euro not needed, just a basic date version). My mysql database column is formatted as "date" 0000-00-00.
Could you please let me know if you ever got this working, and what I am possible doing wrong.
Steps I took:
1. Generated insert form with DataAssist
2. Added datepicker to date field using CSS Form Builder
3. Re-Binded Insert SB to new CSS Form Recordset values
4. Applied client side validation on date field (allow mm/dd/yyyy) and reformat to (yyyy/mm/dd) I also tried reformat to (yyyy-mm-dd) via Behaviors Panel > WA Validation Toolkit > Apply Client Validations > Date/Time.
On form submission, displays "invalid format" and will not submit.
Attached is my code and screenshots.
Thanks for any help. D.