topic Re: the date format ? in QlikView

the date format ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

Please assist me to get the date format - DD/MM/YYYY in the below model.

Model attached.

Re: the date format ?

PrashantSangle — Wed, 19 Jul 2017 10:28:22 GMT

Hi,

Use

as calculated Dimension

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

REgards,

Re: the date format ?

rahulpawarb — Wed, 19 Jul 2017 10:28:29 GMT

May be this:

=Date([Depot Order_Date], 'DD/MM/YYYY')

Regards!

Rahul Pawar

Re: the date format ?

Anil_Babu_Samineni — Wed, 19 Jul 2017 10:28:39 GMT

May be do Calculate dimension for that field or use in script same manner

=Date([Depot Order Date])

Re: the date format ?

Anonymous — Wed, 19 Jul 2017 10:36:36 GMT

See .qvw attached.

As people above said but I have made the changes in the attached file for a practical view.

Regards

Re: the date format ?

sunny_talwar — Wed, 19 Jul 2017 11:13:03 GMT

You can also permanently change the format of Depot Order_Date field by going to document properties -> Number and set a new format which would change its format throughout the dashboard