How to compare two string variables containing "DD/MM/YYYY HH24:MI:SS" data
652429May 12 2010 — edited Feb 27 2020Hi,
A process that I am working on receives two string fields holding date/time data in the format "DD/MM/YYYY HH24:MI:SS"
e.g. "12/03/2010 16:00:00" & "29/03/2010 18:10:57"
I need to compare these two variables in order to determine which contains the greater (most recent) date.
I am not sure whether I should be using format-dateTime() xpath function on both strings, and then comparing the result of these two conversions. I think not.
Any assistance/pointers is greatly appreciated.
Regards - Anit