Discussion board where members can get started with Qlik Sense.
My date format is as shown in attachment.
Can you please suggest how to date in DD-MM-YYYY format
if the above don't work, you should know what is your date field source date format
Dealing with date formats in QlikView and QlikSense
Go to Data Manager than Table Overview
than click the Pen icon(Edit this table)
than click the field format (just above the field name)
Input format and
To test if the source data is really a date you can use:
Logical Functions (IsNum)
Returns -1 (True) if the expression can be interpreted as a number, otherwise 0 (False).
IsNum( expr )
Dates should return just like a number. This helps ensure that you have not inadvertently converted your "date" to a varchar representation of a date.
and maybe you can recommend him something to help him solve his problem?
Also, to ensure you retain the date-formating you should wrap your fields in the Date() function in your last load.
Date(SomeDate) AS SomeDate
** Please mark the comment helpful if it was useful in resolving your issue. Thanks! **