Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator 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
Champion
Champion

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

shakil4sk
Contributor
Contributor

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
Specialist
Specialist

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
Champion
Champion

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

wdchristensen
Specialist
Specialist

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
Not applicable

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