Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Format layout of Question type – Date

  • dtrindade
  • dtrindade's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 2 days ago #118364 by dtrindade
Format layout of Question type – Date was created by dtrindade
When I export the answers to excel format, in the “Question type – Date” appear in the following format: 2015-03-11 00:00:00, how can I do so only to be exported the date 2015-03-11? And not the date and time?
The same happens in the answer print, if I use date1.shown, shows 3/11/2015 0:00:00 and and I just want 03/11/2015.

I’m using the version 2.00+ Build 130406
The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 1 day ago #118374 by tpartner
Replied by tpartner on topic Format layout of Question type – Date
As far as I know, there is no way to fix the export without hacking the core code. But it's fairly simple to search and replace those values in Excel.

As for the print-answers, this is fixed in 2.05 so an update may be due.


.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose