Compare two datetime values

[former_member496802]

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/b4f08a9a66434327a405b69348... ?

Thank you!

Best Regards,

Artem

[former_member671720]

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

[former_member496802]

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

[former_member671720]

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

[JonasB · Accepted solution]

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

[JonasB · Accepted solution]

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}}

[former_member496802 · Accepted solution]

Hi Jonas,

It is what I need! Thank you!

Best Regards,

Artem

[alichtenau]

Hi Artem,

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

Best regards,
Andreas

[former_member496802]

Hi Andreas,

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

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

Thanks!

Best Regards,

Artem