Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
csv output giving multiple date format while using etext template
Summary:
I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when i copy the output to a excel or save and open the csv file, the column shows the output in different formats . The column derives value of date_start of per_periods_of_service table. Require all the rows to be in dd-mm-yyyy format. i have tried this using to_char function in query and also format_date in etext template but still the issue is there
Content (please ensure you mask any confidential information):
Tagged:
0