Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

Date Time Function

Hi,

How qlikview will consider the date 03/03/2012 12:00:00  and 3/3/2012 12:00:00. ,I am getting different date representation in QlikView.

1 Reply
Anonymous
Not applicable

You can format the date any way you want in QV.  Your first example is MM/DD/YYYY hh:mm:ss, while the 2nd is M/D/YYYY...
Go to the document properties, field numbers, and verify the format of your date fields.
By default, the date is formatted according to thge settings in the beginning of the script - but the result depends on if you use date() function in the script, if you overriding the default format in this function, etc.