Skip to Content
0
Jul 27, 2023 at 07:37 PM

CDS View: Timestamp Comparison

36 Views

Hello *,


I want to compare two timestamps in a CDS view and derive a result. However, the comparison does not seem to work. What am I doing wrong? is the comparison even possible?

case when FinishDateAsTimestamp < DueDateAsTimestamp then 'C' // SLA complied

when FinishDateAsTimestamp > DueDateAsTimestamp then 'M' // SLA missed

end as SLA_Result

grafik.png

Thank you for answers,
David

Attachments

grafik.png (17.8 kB)