What's new in Customer Journeys?

Connect and learn more!
csv output giving multiple date format while using etext template — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

csv output giving multiple date format while using etext template

Received Response
34
Views
9
Comments

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!