Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
qliksus
Specialist II
Specialist II

Applying date format for the whole table

Guys ,

My requirement is that i have to keep the date format same for more than 100 date columns

Currently i have a table with around 150 columns out of that there are 50 date columns

each of this date columns are having different format i need to covert this into a same format

Yes i can give date function to all this 50 columns and achieve that but i dont want to do that

Because i have to do this in more than 50 tables .So my question is how can i specify a

date format for the whole table like If if give  SET DATEFORMAT = 'DD/MM/YYYY'  at the top of

the table it will reflect in all the date columns present below so how can i achieve this or is it possible

2 Replies
Not applicable

If you just have to display all those dates in the front end then

In Document Properties--> Number --> all the date the fields and choose the date format from over there then the dates will be shown accordingly.

Regards,

Nitin Jain

qliksus
Specialist II
Specialist II
Author

No i want to do that in that in Edit script