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
It converts to 6/11/2021 in excel
@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.