idea Re: Timestamp Input Format Detection (DD-MMM-YY hh:mm) - Status changed to: Open - New in Suggest an Idea

Timestamp Input Format Detection (DD-MMM-YY hh:mm)

pleddy — Tue, 15 Dec 2020 22:00:02 GMT

With Qlik Sense Data Manager, there is a common timestamp/date input format of DD-MMM-YY or DD-MMM-YYYY that doesn't seem to be automatically detected with autocalendar if importing with a CSV file. Additionally, the input format is not available in the default dropdown. Consider adding this to the default dropdown as it is a pretty standard data format used internationally to avoid confusion between MM/DD and DD/MM approach that differs between geos.

Currently supported for detection in CSV are:

M/D/YYYY h:mm
D/M/YYYY h:mm TT
M/D/YYYY
D/MM/YYYY
YYYYMMDD
YYYYMMDDhhmmss
YYYYMMDDhhmmss.fff
YYYYMMDDhhmmssK
YYYY-MM-DD
YYYY-MM-DDThh:mm:ss
YYYY-MM-DD-Thh:mm:ss.fff
YYYY-MM-DD-Thh:mm:ssK

Consider adding

DD-MMM-YY
DD-MMM-YYYY
DD-MMM-YY hh:mm:ss
DD-MMM-YYY hh:mm:ss

Re: Timestamp Input Format Detection (DD-MMM-YY hh:mm) - Status changed to: Open - New

Ian_Crosland — Wed, 09 Dec 2020 15:08:46 GMT

Re: Timestamp Input Format Detection (DD-MMM-YY hh:mm) - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Tue, 23 Feb 2021 09:30:01 GMT

Thank you for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks,

Patric

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Tue, 05 Sep 2023 13:17:34 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Timestamp Input Format Detection (DD-MMM-YY hh:mm) - Status changed to: Closed - Archived

Ideation — Tue, 05 Sep 2023 13:17:36 GMT