Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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