CDS View in S/4Hana Cloud converting date format

[tuliovargas]

Hi folks,

I am creating a custom CDS View to use in the "Custom Analytical Queries", my question is about date format, How I can convert a date from YYYY-MM-DD to DD/MM/YYYY?

Thanks

[tuliovargas · Accepted solution]

The solution using calculation:

concat(concat(concat( substring(Date_Column, 7, 2) ,'/') , concat( substring(Date_Column, 5, 2), '/' )),substring(Date_Column, 1, 4))

Regards

[JTR · Accepted solution]

Applied this solution and it worked perfectly. Thank you for this Tulio.

"Date_Column" should be switched by the respective Element/Attribute which takes the respective date.