Skip to Content
1
Oct 22, 2018 at 06:54 AM

Custom CDS View convert Decimal Field to Date

2586 Views Last edit Sep 17, 2023 at 01:48 PM 2 rev

Hi;

I like to determine the period when a project has been created or last updated. For this I like to first convert the CreatedDateTime field which is a decimal to a Date Field so I can link it to the FiscalYear view.

I tried cast( I_EngProj.CreationDateTime as ABAP.DATS ) but I am getting the error "CAST CREATIONDATETIME of type DEC to type DATS is not possible".

Does anyone know how this can be achieved?

Thanks

Thomas