View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
16976 | Bug reports | Survey participants (Tokens) | public | 2021-01-13 20:29 | 2021-01-13 20:29 |
Reporter | PPRI | Assigned To | |||
Priority | none | Severity | minor | ||
Status | new | Resolution | open | ||
Product Version | 3.25.6 | ||||
Summary | 16976: Date format problem | ||||
Description | I think Limesurvey's defalut date format is dd.mm.yyyy. If the date format is changed to mm.dd.yyyy, A wrong date(month and day are switched) is being loaded on the sent or reminder sent date field when you try to edit a survey participant token information. For an example, If 'sent' or 'reimindersent' date was 1.12.2021(Jan. 12 2021), 12.1.2021(Dec. 1 2021) is loaded. If it was 1.13.2021(Jan. 13 2021), 01-01-1800 is loaded because month 13 doesn't exist. I believe it's because database date type for 'sent' and 'remindersent' fields are string, not datetime like validfrom or validuntil fields so the personal date format selection is not working correctly. | ||||
Steps To Reproduce |
| ||||
Additional Information | I have tested it on 3.25.4 (Your hosting server version) and on Version 4.3.33(Your Demo server version) and all have the same problem. | ||||
Tags | No tags attached. | ||||
Complete LimeSurvey version number (& build) | Version 3.25.7+210113 | ||||
I will donate to the project if issue is resolved | No | ||||
Sync to Zoho Project | |||||
Browser | Google Chrome | ||||
Database & DB-Version | MS SQL 12.00.6024 | ||||
Server OS (if known) | Windows NT 10.0 build 14393 (Windows Server 2016) AMD64 | ||||
Webserver software & version (if known) | Microsoft-IIS/10.0 | ||||
PHP Version | 7.3.11 | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2021-01-13 20:29 | PPRI | New Issue |