You can turn you string into a date time and use that to compare
date1=Datetime.ParseExact(“13/08/2019”,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)
How do i convert a string into a datetime ? What i get from get text activity its 00/00/0000 assume thats the correct format. But want to know how i can make a function thats checks if there its more than one column then check next coumn to see if the date are more recent than the other one
A lot of people keep asking and a lot of people keep answering how to convert string into datetime. Just click and read a little. I send you a code snippet to work with. See my last linked post how to check for the most recent date.
Code snippet
I usually use check if format and date are valid with DateTime.TryParseExact(myDateString,myDateFormat,Nothing,System.Globalization.DateTimeStyles.None,sampleDate)
then actually parse it with DateTime.ParseExact(myDateString, myDateFormat, System.Globalization.CultureInfo.InvariantCulture)
Otherwise I can recommend the academy courses to learn about automation basics like using a for each loop and stuff.