DateTimeFormat error

[carterfleming]

I'm trying to achieve three goals with a single Formula tool. First, I'm filling Nulls in one date column with dates from another column:

Then, I'm trying to ensure that the formatting for this column is in proper format. For reference, the existing column that originally had Nulls was not formatted in Alteryx date format, but the column I pulled in to fill the Nulls was already in Date format.

Finally, I want to create a new column that populates the last day of the month for whatever date is in the Billing Period column. For example, if Billing Period = 2022-01-05, I want this new column to populate as 2022-01-31.

My issue is that I keep getting a ton of conversion errors saying that some months are not valid Dates or Time.

I've searched all over the Alteryx discussion boards and haven't been able to find a solution that fits this scenario exactly. Any and all help is greatly appreciated!

[binuacs]

@DavidSkaife I think the DateTimeFormat function only takes Date/DateTime data types, can you test ?

[DavidSkaife]

Hi @binuacs 

Already tested before posting:

The date itself must be in the ISO standard format though, otherwise it won't work.

[binuacs]

@DavidSkaife okay , it should be in ISO format, that is the catch . I was testing different format, Thanks 😊