JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Changing Excel & CVS Spreadsheet time stamp optionsAsked by WCAA2012 on December 02, 2014 at 04:05 PM
When I upload an xlsx or cvs file of survey responders, the timestamp in the cells looks like: 2014-12-02 14:20:23
When I click in the cell to edit it, (in xlsx or cvs format, using google docs or office libre) it looks like: 12/2/2014 14:20:23
After I save the file to xls, the type of file my database can read, the date stamp stays 2014-12-02.
For the purposes of uploading the data to my database using scripts, I need the date format to be in forward slashes "/" instead of " - "
Thank you for contacting us.
You can easily change the date format on downloaded .xlsx file via Google Spreadsheets and Microsoft Excel. Unfortunately, the Google Spreadsheets service does not support saving with the .xls format anymore, but it is supported in Microsoft office.
Can you check if this is possible to change the date format and save the file as .xls in LibreOffice?