How to reliably compare date time values?

I’m trying to compare datetime values across two systems.

Dates are entered into both systems in the format YYYY-DD-MM HH:MM A. Both systems are set to use the timezone.

They both show the same date value in the user interface. Yet when I perform a datetime equality test, it fails.

i converted one datetime value using the formatDate function, and the resulting string had an extra 3 mins in the minutes value yet in the UI it shows 00.

Is there a reliable way to compare dates?

Hi. If you are doing this in an filter, compare it as text not as datetime.

Don’t hesitate to contact us if you require further assistance.


1 Like

Thanks for the suggestion. I’m doing it in a datastore search. It is perplexing.