Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
kishorj1982
Contributor II

Date Format

Hi All,

PFA

My date format is as shown in attachment.

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

Thanks

7 Replies
YoussefBelloum
Esteemed Contributor

Re: Date Format

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
Valued Contributor

Re: Date Format

shakil4sk
New Contributor

Re: Date Format

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
Valued Contributor

Re: Date Format

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
Esteemed Contributor

Re: Date Format

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

wdchristensen
Valued Contributor

Re: Date Format

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

robin_hausdoerfer
Valued Contributor III

Re: Date Format

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