Check out the LimeSurvey source code on GitHub!

Date entries issues

More
5 years 10 months ago #58957 by CarlSeiler
Using v 1.90+ on paid limequery service to enter paper-based surveys. I'm finding that one question even though set to Date as question type has a couple of questions.

1) When entering date on data entry screen, cannot easily type in date. Even though I managed somehow to get it set to MM/DD/YYYY format, it seems to want periods (.) as the delimeter, and this is unnatural for our data entry. Can we specify slashes (/) instead? It seems to ignore those.

2) Even though date range is set to 1901 min to 2011 max, the data entry screen only allows dates from 2001 to 2021 on the calendar date picker. Is this a problem?

Please Log in to join the conversation.

More
5 years 10 months ago #58958 by CarlSeiler
I think the date format is more off than I thought. It recorded 11.15.1955 as 11.03.1956 which makes me think it's maybe recording them as dd.mm.yyyy instead of the desired format.

Please Log in to join the conversation.

More
5 years 10 months ago #58983 by tpartner
You can set the date format in the survey settings:


Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Attachments:

Please Log in to join the conversation.

More
5 years 10 months ago #59006 by CarlSeiler
Date format is specified as mm/dd/yyyy, so I don't think that's it. I assume you're talking about the Surevey Settings|General tab then clicking on Save and Continue at the bottom. (This is tough to find as I expect to see all of the options when I'm looking at things and that one is hidden until you click save and continue). If that's not where you're talkin about, please give me exact instructions on how to find it.

Please Log in to join the conversation.

More
5 years 10 months ago #59008 by CarlSeiler
OK, the setting seems to affect only the full-featured survey, not the data entry screen. So June 20, 1960 is entered as 06/20/1968 on the main survey, but on the data entry screen it must be entered as 20.06.1968. I'm not sure which is going to be faster for us to use, but I think that could lead to some entry errors on the data entry version.

Please Log in to join the conversation.

More
5 years 10 months ago #59009 by tpartner

I assume you're talking about the Surevey Settings|General tab...

Yes, that's what I mean.

OK, the setting seems to affect only the full-featured survey, not the data entry screen.

This would seem to be a bug. In my opinion, the date format setting should control both survey submissions and manual data entry for a given survey (that's why it's survey-specific).

Please open a ticket at the Bugtracker and...

1. Give as much information as possible

2. Attach your survey. You can mark your ticket "private" so that only the developers will be able to take a look at it.

3. Provide step-by-step instructions how to reproduce the problem.

4. If possible/helpful please provide screenshots

Afterwards please post the link to the Bugtracker so we can follow the progress.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
5 years 10 months ago #59019 by DenisChenu

tpartner wrote: This would seem to be a bug. In my opinion, the date format setting should control both survey submissions and manual data entry for a given survey (that's why it's survey-specific).

I 'm not sure, date format change for each langage.

Maybe it's the user choice ( /admin/admin.php?action=personalsettings ) to have the "last word".

Then a french user can use dd/mm/yy and an english user in the same survey mm.dd.yy .

CarlSeiler can you test with changing in personnal settings please ? (click on your name at the first line in admin age)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

More
5 years 10 months ago #59021 by tpartner

Maybe it's the user choice

I don't think the data-entry format should be a user choice. I think it should be the same as the survey submission data to keep consistent data.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
5 years 10 months ago #59024 by CarlSeiler
Shnoulle, that is it. It seems that the data entry is based on user settings.

tpartner, the data is consistent probably as the data is saved as a date value of some sort and not as a string I would guess.

Please Log in to join the conversation.

More
5 years 10 months ago #59078 by Mazi
Just to check if I got this right: You can set a dateformat for surveys like YYYY-MM-DD while having another personal date setting (bound to the login name?) that can differ like DD.MM.YYYY?

That would be really strange and I would think that at the data entry screen the survey date format should be used but this doesn't seem to be the case?!

In general it doesn't matter because the internal storage at the database is fixed, but I find this behavior a little irritating.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
5 years 10 months ago #59097 by DenisChenu
Each survey don't have unique date format, you have to choose date format according to the langage.

Like you say, date is stored in date SQL format, it's only for easy fill date . I think it's best the user can choose is date format.

One thing to do maybe , is to specified default date format for each langage. For example, in french, it's dd/mm/yy , then if i select french langage , date format put by default to dd/mm/yy etc ....

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form