- Posts: 27
- Thank you received: 0
Ask the community, share ideas, and connect with other LimeSurvey users!
Could you share me this easy way pls?holch wrote: Especially as you can correct this fairly easy in Excel.
holch wrote: Well, depending on the number of response I would either look for a formula on how to convert 2012-02-14 into 14.02.2012.
But if the number of entries and the time range isn't too big, I would sort the table regarding date and then copy the correct date to all from the same day. If you have a survey going on for many days, then this is of course quite tedious. Then I would look into formulas in Excel to convert this. If you want to go the formula way, this could be a start. Someone is trying to do the exact oposite of you, but it should give you some idea on how to proceed.
superuser.com/questions/793137/how-to-co...-mm-dd-in-excel-2007
DateTime format in SQL : always Y-M-D h:m:steksur wrote: In datebase date is in right format for me dd.mm.yyyy so in export you have code that will change that to yyyy-mm-dd and add time 00:00:00(I don't know why, not needed at all)
I was little confused, because you said earlier that "Because : we always use english date format when exporting." You are right it is in database this yyyy-mm-dd format. But you are able to show this in in my format dd.mm.yyyy in Browse responses -> Display responses. Everything is fine for me in there. Why I can't have this to Excel?DenisChenu wrote:
DateTime format in SQL : always Y-M-D h:m:steksur wrote: In datebase date is in right format for me dd.mm.yyyy so in export you have code that will change that to yyyy-mm-dd and add time 00:00:00(I don't know why, not needed at all)
ANd if you import a 01/02/03 in excel in french or in english : date is different. Using same format , always : you are sure firt is year, seond i month and last is day of month.
Denis
What do you mean by sponsoring?holch wrote: How about sponsoring the feature? As I said, I don't see that anyone will take this over any time soon.
holch wrote: Well, I don't know what the premium package includes (this is from the Limesurvey GmbH), but from what I know it is the comfort update at the moment, which is well worth its money.
The rest is based on Limesurey's current features. If you require different features there are a few options:
- - Make a feature request (which I think you already did) and wait for its implementation. However, just like with other software this might happen, or not. Even if you spend thousands of dollars/euros on commercial survey packages this is not guaranteed. Back in the day when we used a very expensive survey tool we had tons of feature requests, some made it in the package, others didn't.
- Sponsoring: Find a developer that will implement this into Limesurvey, if possible. Of course they probably won't do this for free.
- Implement it as a plugin (if possible).