View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
10943Bug reportsCentral participant databasepublic2016-04-13 22:592020-03-13 18:46
Reporterakeyser Assigned Tocdorin  
PrioritylowSeverityminor 
Status closedResolutionopen 
Product Version2.50.x 
Summary10943: CPDB Attribute of "Date" type does not allow or support more standard date formats
Description

CPDB attributes of "Date" type provide a JQuery datepicker for data entry, but if an alternate date format is to be used, I cannot actually type it into the field.

Steps To Reproduce

Add a CPDB attribute of "date" type
Add a global participant
Click + next to the participant
Double-click on the new attribute
Click in the text box to show a date picker
Pick a date, like April 13, 2016 (today)

  • Jquery datepicker enters 04/13/2016, the US standard date format, but I greatly prefer the ISO 8601 standard of "2016-04-13"

Try to type 2016-04-13, and discover that the text field actively prohibits hyphen characters.

Additional Information

Using ISO 8601 is a preference and is the date format that our clients expect to import data with. While importing this date format from CSV is not a problem, adding a single participant manually to the CPDB becomes an issue, because the date format will not follow the rest of the imported data.

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)160414
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome 49
Database type & versionMySQL 5.6.27-log
Server OS (if known)Windows Server 2008 R2
Webserver software & version (if known)IIS 7.5
PHP Version5.6.14

Users monitoring this issue

akeyser

Activities

DenisChenu

DenisChenu

2016-04-14 09:32

developer   ~37362

Did you set the user parameters to US date format ?
jquery datepicker follow user parameters, but save ISO date in DB.
akeyser

akeyser

2016-04-14 17:40

reporter   ~37386

Yes, user preference is set to "yyyy-mm-dd". Is that preference not being respected in this view?
DenisChenu

DenisChenu

2016-04-14 17:49

developer   ~37387

OK,

Then if user preference are set to "yyyy-mm-dd" : seems to be a bug :).

Can you look at "token table" if it's respect the user preferences too ?
akeyser

akeyser

2016-04-14 17:54

reporter   ~37388

In the token table, attributes do not appear to have an assign-able "type": I cannot set any value to "date" type, so no date pickers ever show as they are all "strings".

That being said, "Valid From" and "Valid To" provide date pickers, and they do show the right date format.
DenisChenu

DenisChenu

2016-04-14 17:57

developer   ~37389

That being said, : :) sorry ... but i don' view where ?

then it's clearly a bug in CPDB :)
c_schmitz

c_schmitz

2016-04-15 15:52

administrator   ~37469

I am afraid this won't be fixed soon as it is quite some effort for very little effect.

akeyser

akeyser

2016-04-15 16:15

reporter   ~37471

While the "effect" of fixing the bug may not be great, the effect of not fixing it does, unfortunately, cause mayhem with sorting on any "date" attributes, both in the CPDB, and later in token tables where the participant is copied to. As it stands, the only way that I (and our client) can get ISO standard date formats into the CPDB is to import them by CSV. This is less than ideal.
c_schmitz

c_schmitz

2020-03-13 18:46

administrator   ~56459

This version of LimeSurvey is not longer supported. Please check so that the issue is fixed in a more recent version of LimeSurvey. If it's not, please reopen this bug report. Thank you.

Issue History

Date Modified Username Field Change
2016-04-13 22:59 akeyser New Issue
2016-04-14 09:32 DenisChenu Note Added: 37362
2016-04-14 16:08 c_schmitz Assigned To => c_schmitz
2016-04-14 16:08 c_schmitz Status new => feedback
2016-04-14 17:40 akeyser Note Added: 37386
2016-04-14 17:40 akeyser Status feedback => assigned
2016-04-14 17:49 DenisChenu Note Added: 37387
2016-04-14 17:54 akeyser Note Added: 37388
2016-04-14 17:57 DenisChenu Note Added: 37389
2016-04-14 21:57 akeyser Issue Monitored: akeyser
2016-04-15 15:25 c_schmitz Sticky Issue No => Yes
2016-04-15 15:52 c_schmitz Note Added: 37469
2016-04-15 15:52 c_schmitz Assigned To c_schmitz =>
2016-04-15 15:52 c_schmitz Status assigned => acknowledged
2016-04-15 15:54 c_schmitz Sticky Issue Yes => No
2016-04-15 16:15 akeyser Note Added: 37471
2016-05-17 14:17 c_schmitz Priority none => low
2019-09-23 12:18 c_schmitz Status acknowledged => confirmed
2019-11-26 17:59 cdorin Assigned To => cdorin
2019-11-26 17:59 cdorin Status confirmed => assigned
2020-03-13 18:46 c_schmitz Note Added: 56459
2020-03-13 18:46 c_schmitz Status assigned => closed
2021-08-04 20:19 guest Bug heat 6 => 8