Question Re: Compare two datetime values in Technology Q&A

Compare two datetime values

former_member496802 — Thu, 06 Aug 2020 22:22:24 GMT

Hello everyone,

I have a scenario where I need to compare (two datetime entity values) | (datetime entity with api response date), is it currently possible? Maybe there are helpers like for date formating https://help.sap.com/viewer/a4522a393d2b4643812b7caadfe90c18/latest/en-US/b4f08a9a66434327a405b6934880445c.html ?

Thank you!

Best Regards,

Artem

Re: Compare two datetime values

alichtenau — Fri, 07 Aug 2020 05:21:47 GMT

Hi Artem,

what would you like to compare? Which date is older, which date is "younger"?

Best regards,
Andreas

Re: Compare two datetime values

former_member671720 — Fri, 07 Aug 2020 05:41:53 GMT

HI artem.sharganov

There is compare helper available, I believe you want to compare api response date with a static date, then you can use this

{{#compare (formatDate api_service_response.InvoiceByDate.body.d.results.[0].InvoiceDate 'DD-MM-YYYY') '===' '01-05-2018'}}
    Dates are equal
{{else}} 
    Not equal
{{/compare}}

Regards
Kishore

Re: Compare two datetime values

former_member496802 — Fri, 07 Aug 2020 09:07:53 GMT

Hi Andreas,

Yes, that is right. The complete scenario is the following:

I am getting the response from api with date field.
I need to compare (younger, older) it with a current datetime. Current datettime I am getting from {{message_received_at}}

Thanks!

Best Regards,

Artem

Re: Compare two datetime values

former_member496802 — Fri, 07 Aug 2020 09:30:41 GMT

HI @kishore96,

Good idea, thank you!

I think if I format the datetime like "YYYY.MM.DD", javascript operators can help to compare (younger, older) two datetimes even if values are strings. It should work because of the lexicographical order.

Do I miss any case when it doesn't work? What do you think?

Best Regards,

Artem

Re: Compare two datetime values

JonasB — Fri, 07 Aug 2020 11:15:28 GMT

Hi Artem,

another option would be to use the "formatDate" helper to convert the dates to a unix millisecond timestamp and then compare those numeric values with the greater than or lower than helpers:

{{#gt (formatDate "01-31-2020" "x") (formatDate "01-30-2020" "x") }}
...
{{/gt}}

Regards
Jonas

Re: Compare two datetime values

JonasB — Fri, 07 Aug 2020 11:18:12 GMT

By the way: To get the current timestamp, you can use the formatDate helper without providing a date. So if I understand your requirement correctly, it would look like this

{{#gt (formatDate memory.myDateVar "x") (formatDate "x") }}
...
{{/gt}}

Re: Compare two datetime values

former_member496802 — Fri, 07 Aug 2020 11:26:26 GMT

Hi Jonas,

It is what I need! Thank you!

Best Regards,

Artem

Re: Compare two datetime values

former_member671720 — Sat, 08 Aug 2020 06:26:16 GMT

Hi artem.sharganov

I have tried using javascript operators like "===" or "<=" or ">=" in the compare helper and all the use cases with different dates which i tired are working fine, I am not sure about the case where this method does not work.

{{#compare (formatDate api_response.Date 'YYYY-MM-DD') '<=' '2018-05-02'}}
   yes the date is less
 {{else}}
   not less
{{/compare}}

I Think comparing numeric values is better which is suggested by Jonas.

Regards
Kishore