How to reliably compare date time values?

Questions & Answers
1

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?

2

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.

Cheers
//HFBR

1 Like
3

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