View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
17556Bug reportsSurvey participants (Tokens)public2022-10-25 04:57
ReporterPPRI Assigned Togalads  
PrioritynoneSeverityminor 
Status acknowledgedResolutionopen 
Product Version5.x 
Summary17556: sent and remindersent of token is being recorded in the date form of admin user perference.
Description

As you know, the data type of sent and remindersent field in the token table is nvarchar, not dateatime.
Previously in the version 3.xxx, the date for sent and remindersent were recorded in yyyy-mm-dd format regardless of the admin user's preference but in version 5.xxx, the date is recorded in the date format of admin user's preference.

As a result, if users have different date format preference, the value of sent and remindersent field are messed up in the different format.

Steps To Reproduce

change the admin user's data format at My Personal Settings and send an invitation or reminder. If you check the db values, the string value of datatime of sent and remindersent will be in the different date format.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)Version 5.1.5+210830
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome Version 92.0.4515.159
Database type & versionMS SQL 12.00.6164
Server OS (if known)Windows NT 10.0 build 14393
Webserver software & version (if known)Microsoft-IIS/10.0
PHP Version 7.3.11

Users monitoring this issue

There are no users monitoring this issue.

Activities

Issue History

Date Modified Username Field Change
2021-08-30 16:58 PPRI New Issue
2021-08-31 07:52 galads Assigned To => galads
2021-08-31 07:52 galads Status new => acknowledged
2022-10-25 04:57 gitahubert Note Added: 72396
2022-10-25 04:57 gitahubert Bug heat 0 => 2