View Issue Details

IDProjectCategoryView StatusLast Update
16976Bug reportsSurvey participants (Tokens)public2021-01-13 20:29
ReporterPPRI Assigned To 
Status newResolutionopen 
Product Version3.25.6 
Summary16976: Date format problem

I think Limesurvey's defalut date format is 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.

TagsNo tags attached.
Complete LimeSurvey version number (& build)Version 3.25.7+210113
I will donate to the project if issue is resolvedNo
Sync to Zoho Project
BrowserGoogle Chrome
Database & DB-VersionMS 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 Version7.3.11


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2021-01-13 20:29 PPRI New Issue