Date Format

[Anonymous]

Hi,

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

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

Please advise. Thanks!

[sunny_talwar · Accepted solution]

Use Date() function while loading:

Date(DateFieldName) as DateFieldName

[eespiritu]

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]

Thanks Sunny!

[Anonymous]

Thanks Enrique. When do we use Date#?

[sunny_talwar]

Read here:

QlikView Date fields

Why don’t my dates work?

Get the Dates Right

[eespiritu]

You're welcome,

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