Date manipulation in CDS Views

   //Travel.end_date        as EndDate,

      cast( 

      concat(

        concat(

          concat(substring(Travel.end_date, 7, 2), '.' ),

          concat(substring(Travel.end_date, 5, 2), '.' )

        ),

        substring(Travel.end_date, 1, 4)        

      )

    as abap.char( 10 )) as EndDate,

Fiori output :