Date Format

[kishorj1982]

Hi All,

PFA

My date format is as shown in attachment.

Can you please suggest how to  date in DD-MM-YYYY format

Thanks

[YoussefBelloum]

Hi,

try this:

=Date(date_field,'DD-MM-YYYY')

if the above don't work, you should know what is your date field source date format

[isingh30]

Dealing with date formats in QlikView and QlikSense

[shakil4sk]

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)

Change the

Field Type,

Input format and

Display format

[wdchristensen]

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.

[YoussefBelloum]

and maybe you can recommend him something to help him solve his problem?

[wdchristensen]

Date Function

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! **

[Anonymous]

date(num#(YOURFIELD),'DD-MM-YYYY')