Hi @khalidmayson
I hope you are doing well.
I see it is sending the timestamp to the integration instead of the converted date.
If you copy and paste the value on this site https://www.epochconverter.com/ you should get the correct day.
I tested on my end but it worked as expected:
https://monosnap.com/file/a5DLo7tLl4uKYRAw668dPkfr4uDQLC
Could you export your form and we can take a closer look? https://wpmudev.com/docs/wpmu-dev-plugins/forminator/#import-export
Please, share using Google drive or any similar service.
Best Regards
Patrick Freitas
Hi @khalidmayson
I hope you are doing well and safe!
We haven’t heard from you in a while, I’ll mark this thread as resolved.
Feel free to let us know if you have any additional questions or problems.
Best Regards
Patrick Freitas
Hello @wpmudevsupport12
sorry for the long wait I forgot to check my email sometimes, anyway here is the export of my form :
https://drive.google.com/file/d/1PcGZE-nXIjpokNUjtQHucyQvmlhk4jWD/view?usp=sharing
should I do something to the date field ? or leave it as is and how can i convert date automatically in google sheets.
thanks a lot
Hello @khalidmayson !
Hope you’re doing well!
Can you confirm that the date field was always set up like this and recorded to the spreadsheets? From what I see, in one of the previous submissions there’s an IP address saved there.
I tested the form on my test site, but it saved the date correctly to the submissions.
As for the conversion – the date is being saved in Sheets as a timestamp. You can check this article on how to convert it: https://www.extendoffice.com/documents/excel/2473-excel-timestamp-to-date.html#a3
Kind regards,
Pawel
