Question
Tata Consultancy Services
MX
Last activity: 16 Jul 2017 5:59 EDT
Need to set Date Format as DD/MM/YYYY while displaying report
While displaying report through Report Definition we have a Date field. If we run the same report definition with different user Ids on different machines then the Date format is changing. Sometimes it is coming as 'MM/DD/YYYY' ,sometimes 'MM/DD/YY' ,sometimes 'MM-DD-YY' or sometimes as 'DD-MM-YY'. Everytime it should come in constant format as 'DD/MM/YYYY'. We tried keeping the format in the column as 'Localized java 'short' Date format'. But it did not help. I think it is taking local date format of system by doing this.
Can anyone please provide a solution