Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
No i want to do that in that in Edit script