Operations with dates in abap cds

[former_member609155]

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

[maheshpalavalli]

Try passing it like yyyymmdd 20191204

[former_member609155]

Thanks so much

[GK817]

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

GK

[former_member1716]

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!