LINQ for filtering dates

We have a date column with dates (MM/dd/yyyy) in string format.
I have to check which all dates when substracted from todays date are multiples of 5 years i.e., even the month and days have to be taken into consideration.
I simply have to filter these dates and retrieve the employee id’s & Respective dates in table format.
PFA Excel for referenceRecords.xlsx (339.0 KB)

Thanks in advance!!
@ppr @Yoichi

Hi @nikhil.girish
Could u check this workflow
data.xaml (5.8 KB)
Records.xlsx (358.6 KB)

Records — sheet 2 had output

Regards,
Nived N

1 Like

Thanks @NIVED_NAMBIAR:slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.