Random Date Column Records Retrieval

[Ishan_Shelke1 (Ishan Shelke)]

I have a excel sheet without headers which has data in a format like this

What I want to do is

Retrieve the whole row where the date 20-05-2022 is appearing, well 20th May is just an example the date changes everyday

So basically the output that should I get is

A,20-05-2022
C,20-05-2022
H,20-05-2022
J,20-05-2022

Excel File -
Book1.xlsx (9.0 KB)

[Ashish_Soni]

Hi @Ishan_Shelke1 ,

Please check the attached workflow.
Hope it will help.

Cheers,

GetRowWithDate.xaml (7.3 KB)

[jack.chan]

try this
Testx.xaml (16.9 KB)

result (converted resultDt to string (resultDtTxt) and printed it out)