Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

DateTimeParse Issue - year 1800s not parsing

HarryRoles
7 - Meteor

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!

 

10 REPLIES 10
echuong1
Alteryx Alumni (Retired)

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.

Labels