For each loop to read dates

excel-loop
#1

Hi There!
I am having issues in for each loop. I am pulling the Date list (text format) from excel and putting in the list variable. I want to match the current date 05/15/2019 (string variable) in the list. My loop is not matching. I tried equal, contains, match expression. but nothing is working. Once matched, I need to record the output in another string variable.
See attached images
Can you advise, where I am going wrong?

Capture

#2

Can you share the screenshot of your Date Format action?

#3

#4

You need another format in the output: MM/dd/yyyy instead of MM/dd/yy.
The dates in the list are written in this format

#5

Thanks it worked !

1 Like