Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

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

pleddy
Employee
Employee

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

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
4 Comments
Ian_Crosland
Employee
Employee
 
Status changed to: Open - New
Patric_Nordstrom
Employee
Employee

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

Status changed to: Open - Collecting Feedback
Meghann_MacDonald

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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived