https://community.sap.com/t5/application-development-and-automation-discussions/cds-view-timestamp-comparison/m-p/12736359#M2020784 <P>Hello *,</P> <P><BR />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? </P> <P> case when FinishDateAsTimestamp &lt; DueDateAsTimestamp then 'C' // SLA complied </P> <P> when FinishDateAsTimestamp &gt; DueDateAsTimestamp then 'M' // SLA missed</P> <P> end as SLA_Result</P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2188881-grafik.png" /></P> <P>Thank you for answers,<BR />David </P> Thu, 27 Jul 2023 19:37:28 GMT david_hesse 2023-07-27T19:37:28Z https://community.sap.com/t5/application-development-and-automation-discussions/cds-view-timestamp-comparison/m-p/12736359#M2020784 <P>Hello *,</P> <P><BR />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? </P> <P> case when FinishDateAsTimestamp &lt; DueDateAsTimestamp then 'C' // SLA complied </P> <P> when FinishDateAsTimestamp &gt; DueDateAsTimestamp then 'M' // SLA missed</P> <P> end as SLA_Result</P> <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/2188881-grafik.png" /></P> <P>Thank you for answers,<BR />David </P> Thu, 27 Jul 2023 19:37:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/cds-view-timestamp-comparison/m-p/12736359#M2020784 david_hesse 2023-07-27T19:37:28Z