Welcome to the LimeSurvey Community Forum

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

Date format issue with export

  • S2_EducaNum
  • S2_EducaNum's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 3 months ago #209795 by S2_EducaNum
Date format issue with export was created by S2_EducaNum
Hello,

I have recently changed my old 2.6 LimeSurvey to 4.3 version and something annoying appears.

In my form, there are questions with date (like birthdate, timestamp, ...). In the past, when exporting to .xls, date format were perfectly correct (we use DD.MM.YYYY).

Now, with the 4.3 version, I'm not able to get anything else than a YYYY-MM-DD format. As I saw in this old topic , export keeps the database format.

But, it's only true for an export to .xlsx, the .csv one works fine.

Is there any solution about that? I mean, anything else than going to Excel, select columns > Data > Text to Columns :P

Thanking you in advance for your answers, I wish you a merry Christmas and an happy New Year!
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 3 months ago #209803 by Joffm
Replied by Joffm on topic Date format issue with export
But it is easy to handle.

After exporting this entry


I got


Here I propose the same as in the thread you mentioned
Add a column after the date with the formula: "=LEFT(ZS(-1);10)*1" and a "Format: date" will result in:

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • S2_EducaNum
  • S2_EducaNum's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 3 months ago - 3 years 3 months ago #209808 by S2_EducaNum
Replied by S2_EducaNum on topic Date format issue with export
Hello,

Thank you for your fast reply.
To clarify a bit my request, we are a school with almost 3,000 students. LimeSurvey is used for registration purposes.

Exports and data processing are made by our secretaries. Technically speaking, I can understand that an operation is needed on the column, but I can't respond like this, because it will not be considerate as an adequate answer for them, nor for our Director.

So, the real question is : why date format is exporting correctly with CSV file, but needs an operation with XLSX file? It's just about a simple PHP date() convertion, isn't it?

In any case, I thank you again for you reply and I remain open of any simplification.
Last edit: 3 years 3 months ago by S2_EducaNum.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 3 months ago #209811 by Joffm
Replied by Joffm on topic Date format issue with export
Hi,

It's just about a simple PHP date() convertion, isn't it?

In this case you address the wrong people.
You should file a feature request.

We can only advice to work around.

BUT:
If I export as "*.csv" with "csv field separator: semicolon" I can open the file in EXCEL by double clicking it and I get this


Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 3 months ago #209813 by holch
Replied by holch on topic Date format issue with export

I have recently changed my old 2.6 LimeSurvey to 4.3 version and something annoying appears.

And you have seen that LS 4.3 is not considered stable yet, right? You should have changed to LS 3.x.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 3 months ago #209816 by DenisChenu
Replied by DenisChenu on topic Date format issue with export
My opinion : since we use xlsx : we can export as real datetime format for excel.

Need a bug report/feature request

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose