Hi! So here’s the thing, currently my robot can read date with MM/DD/YYYY format. But there are some cases in which the files that I’m running is formatted is M/D/YYYY or M/DD/YYYY format, specially for months January to September. I tried this regex ^(?:(?:(?:0?[13578]|1[02])(\/|-|\.)31)\1|(?:(?…

Nevermind, The regex from the link helped me. I Just edited it from (\d{2}(\/|-)\d{2}(\/|-)\d{2,4}) to (\d{1,2}(\/|-)\d{1,2}(\/|-)\d{2,4}) Thanks.

Regex to accept date formats m/d/yyyy, m/dd/yyyy and, mm/dd/yyyy format

Thanu_Matheesha1 (Thanu Matheesha) February 28, 2022, 2:54am 2

Check this

1 Like

Topic		Replies	Views
Regex for date formats Academy Feedback regex	9	8922	July 16, 2020
How to make a regex for date format dd yyyy MMMM? Activities activities , regex , question , system , regex-extractor	5	1242	June 3, 2022
Regex Date Help studio , question	11	3249	December 3, 2020
Regex pattern to extract date format ddMMMyyyy Something Else feedback	5	2885	March 27, 2021
Format date in excel - dd.mm.yyyy StudioX studiox , question	12	89	August 22, 2024