Hi all,
I have one column that contains multiple date formats. I would like to format them all as yyyy-mm-dd but some are not recognized as dates. Any help is appreciated, example data is attached
44358 converts to 6/11/2021 in excel
Hi @kevinvozza,
What date format is "44358" how is it structured?
Thanks,
Ira
It converts to 6/11/2021 in excel
Ah thanks I think it is Msdate date. This workflow converts all the rows to dates:
Any questions or issues please ask HTH!Ira
@kevinvozza just updated the formula for Msdate dates I think it should be
DateTimeAdd("1900-01-01",toNumber([Dates])-2,"days")
One way of doing this with a Formula tool:
IF REGEX_Match([Dates], '\d+') then todate(ToNumber([Dates])) else DateTimeParse([Dates],'%Y-%m-%d') endif
Is this the same issue that you posted yesterday? A lot of good options provided there.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multiple-date-formats-in-one-column/m-p/959744#M236463
