Applying date format for the whole table

[qliksus]

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]

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]

No i want to do that in that in Edit script