This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
1. There is a slight change you need to make to the formula. I have swapped 1 & 2 because the format is required Y-m-d but it was in Y-d-m. Please find the formula below. With this date 3 and date 4 is parsed.
No need to give up on pre-1400 dates! You can still use the regex method to parse them, you just can't store them in a date field. Luckily a String(10) field works fine and the yyyy-mm-dd format means that the values sort properly as strings as well. Just make sure to left pad the year with "0" if you go early than 1000 AD