DateTimeParse Issue - year 1800s not parsing

[HarryRoles]

Hi All,

I am currently using the following formula to parse dates all into yyyy-mm-dd format so I can apply the relevant filter to see the data I need. However, when testing, I am finding that it is parsing 1900 and 2000 dates fine, but the 1800 dates have an error. On the alteryx functions the earliest date should go up to 1400, so not sure why I get this error.

Error Message Example:

ConvError: Formula (59): DATETIMEPARSE: Cannot convert "06/06/1800" to a date/time with format "%Y/%d-%m": Month number is out of range 1..12: '1800'

Formula being used:

DateTimeParse([Date of Birth],"%Y/%d-%m")

Appreciate if someone could assist!

[echuong1]

The conditional statement actually updates the date field. Meaning, it will be filled in for all records. You'd only need to filter on that one column after the formula.