topic Re: Operations with dates in abap cds in Application Development and Automation Discussions

Operations with dates in abap cds

former_member609155 — Thu, 05 Dec 2019 14:30:47 GMT

How can I do these operations in abap cds? It doesn't work for me now

maheshpalavalli — Thu, 05 Dec 2019 14:37:56 GMT

Try passing it like yyyymmdd 20191204

GK817 — Thu, 05 Dec 2019 14:40:10 GMT

Hi KJ,

1. Dates should be in format YYYYMMDD.

2. You can also use type conversion, just to be sure. like Cast('20191204' as abap.dats).

Above points should help you resolve your issue.

Regards

former_member1716 — Thu, 05 Dec 2019 19:21:47 GMT

Hello KJ 911,

You can try the below Code, it should work fine.

case
when ( budat <= '20191204' and ( ( augdt = '00000000' ) or ( augdt > '20191204' ) ) )
then 'CXC-DIC' end as December

Regards!

former_member609155 — Mon, 09 Dec 2019 21:33:26 GMT

Thanks so much