View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
17900Bug reportsResponse browsingpublic2022-02-17 13:432022-05-19 17:18
Reportergalads Assigned Togabrieljenik  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version5.2.x 
Summary17900: Response date is incorrect when there is a mis-match in date format
Description

I could reproduce on 2 cloud installations. Attached are screenshots

When there is a mismatch in the date format for the user and the survey, the dates are wrongly displaced. i.e, the submitted dates for the responses are displayed as "1980-01-01"
When you export the responses, you also get the same date as shown in the screenshot above

Steps To Reproduce

Steps to reproduce

(Replace this text with detailed step-by-step instructions on how to reproduce the issue)

Expected result

(Write here what you expected to happen)

Actual result

(Write here what happened instead)

TagsNo tags attached.
Attached Files
Selection_078.png (16,897 bytes)   
Selection_078.png (16,897 bytes)   
Selection_077.png (30,482 bytes)   
Selection_077.png (30,482 bytes)   
Selection_076.png (50,351 bytes)   
Selection_076.png (50,351 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)Version 5.2.13
I will donate to the project if issue is resolvedNo
Browser
Database type & versionN/A
Server OS (if known)
Webserver software & version (if known)
PHP VersionN/A

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-02-17 14:27

developer   ~68318

? i don't understand the issue.
We export all date as SQL format
galads

galads

2022-02-21 11:58

reporter   ~68337

When there is a mismatch in the date format for the user and the survey, the dates are wrongly displaced. i.e, the submitted dates for the responses are displayed as "1980-01-01"

When you export the responses, you also get the same date as shown in the screenshot above
gabrieljenik

gabrieljenik

2022-03-04 15:48

manager   ~68543

We couldn't reproduce it.
Can you please give a step by step or a video?

Sorry to ask, but we are sure that DateStamp setting is activated, right?
galads

galads

2022-04-13 17:47

reporter   ~69062

The issue is if timestamp is not enabled, the submitted_date is shown as 01.01.1980

Solution decided with Gabriel
If date stamp is on, I would show that submit date on the response view.
If date stamp is off, I wouldn't show that submit date on the response view.

These would be a change only on the interface. I would not change the underlying data.
gabrieljenik

gabrieljenik

2022-04-21 19:22

manager   ~69181

PR: https://github.com/LimeSurvey/LimeSurvey/pull/2361
gabrieljenik

gabrieljenik

2022-05-18 02:23

manager   ~69759

Tested it. Pending to be merged
gabrieljenik

gabrieljenik

2022-05-19 12:14

manager   ~69843

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=33494
LimeBot

LimeBot

2022-05-19 17:18

administrator   ~69866

Fixed in Release 5.3.15+220519

Related Changesets

LimeSurvey: master 0c0c86d8

2022-05-19 12:04:00

gabrieljenik


Committer: GitHub Details Diff 		Fixed issue 17900: Response date is incorrect when there is a mis-match in date format (#2361)

Co-authored-by: encuestabizdevgit <devgit@encuesta.biz>		 Affected Issues
17900
mod - application/controllers/ResponsesController.php Diff File

Issue History

Date Modified Username Field Change
2022-02-17 13:43 galads New Issue
2022-02-17 13:43 galads File Added: Selection_078.png
2022-02-17 13:43 galads File Added: Selection_077.png
2022-02-17 13:43 galads File Added: Selection_076.png
2022-02-17 13:43 galads Assigned To => galads
2022-02-17 13:43 galads Status new => confirmed
2022-02-17 14:27 DenisChenu Note Added: 68318
2022-02-17 14:27 DenisChenu Bug heat 0 => 2
2022-02-21 11:58 galads Note Added: 68337
2022-02-21 11:58 galads Bug heat 2 => 4
2022-02-21 11:58 galads Description Updated
2022-02-21 11:58 galads Zoho Project Synchronization Yes => |Yes|
2022-03-04 15:48 gabrieljenik Note Added: 68543
2022-03-04 15:48 gabrieljenik Bug heat 4 => 6
2022-04-13 17:47 galads Note Added: 69062
2022-04-13 17:48 galads Assigned To galads => gabrieljenik
2022-04-13 17:48 galads Priority none => normal
2022-04-13 17:48 galads Zoho Project Synchronization Yes =>
2022-04-21 19:22 gabrieljenik Status confirmed => ready for testing
2022-04-21 19:22 gabrieljenik Note Added: 69181
2022-05-18 02:23 gabrieljenik Status ready for testing => resolved
2022-05-18 02:23 gabrieljenik Resolution open => fixed
2022-05-18 02:23 gabrieljenik Note Added: 69759
2022-05-19 12:14 gabrieljenik Changeset attached => LimeSurvey master 0c0c86d8
2022-05-19 12:14 gabrieljenik Note Added: 69843
2022-05-19 17:18 LimeBot Note Added: 69866
2022-05-19 17:18 LimeBot Status resolved => closed
2022-05-19 17:18 LimeBot Bug heat 6 => 8