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

Date Format

Hi,

The record below is showing the correct date in my qvd file.

item1.PNG

However, when I import the data in my dashboard the date format changes:

item 2.PNG

Please advise. Thanks!

1 Solution

Accepted Solutions
sunny_talwar

Use Date() function while loading:

Date(DateFieldName) as DateFieldName

View solution in original post

6 Replies
sunny_talwar

Use Date() function while loading:

Date(DateFieldName) as DateFieldName

eespiritu
Creator
Creator

Adding Sunny's response, if you need a specific date format, you can add:

Date(DateFieldName,'MM-DD-YYYY') as DateFieldName
Date(DateFieldName,'MM/DD/YYYY') as DateFieldName

Regards,

Anonymous
Not applicable
Author

Thanks Sunny!

Anonymous
Not applicable
Author

Thanks Enrique. When do we use Date#?

eespiritu
Creator
Creator

You're welcome,

Check this discussion: https://community.qlik.com/thread/157281