|
|
| Reporter | PPRI | Assigned To | gabrieljenik | |
|---|
| Priority | normal | Severity | minor | |
|---|
| Status | closed | Resolution | fixed | |
|---|
| 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 | 1. Change the Date Format to mm.dd.yyyy at My Personal Setting.
2. Create a token and send the invitation out.
3. Click 'Edit' on the token.
4. Date/Time field for Sent or Reminder Sent will load the wrong date that month and day are switched. |
|---|
| 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 |
|---|
| 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 |
|---|
|
|
