Solved: the date format ? - Qlik Community

suvechha_b · ‎2017-07-19

Hi All ,

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

Model attached.

PrashantSangle · ‎2017-07-19

Hi,

Use

as calculated Dimension

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

REgards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2017-07-19

Hi,

Use

as calculated Dimension

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

REgards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

rahulpawarb · ‎2017-07-19

May be this:

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

Regards!

Rahul Pawar

Anil_Babu_Samineni · ‎2017-07-19

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

=Date([Depot Order Date])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2017-07-19

See .qvw attached.

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

Regards

sunny_talwar · ‎2017-07-19

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

the date format ?

Related Topics