Condition to Check the date Format

Hello Guys,
My CSV file has a column with DOB, some dates have the “MM-DD-YYYY” format, while some have the “MM/DD/YYYY” format. I would like to know what condition we need to give in “if activity” to change only the rows that contain the “MM-DD-YYYY”.

@Nipun

You can check string contains hyphen “-” or not like below.

        row("DOB").ToString.Trim.Contains("-")

Thank You, Lakshman. Exactly what I needed

1 Like

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