Forum Discussion
Solved
Date remove delimiter
Hi community, How to removed the delimiter between this date format 04/11/2020 for have this format 20200411 ? Have a good day and thanks !
Which date format did you input ? Also, before this new column... is your column formated as date ?
Get this new code:
Date.ToText([Column1], "yyyyMMdd")
I missed the upper double M.
Which date format did you input ? Also, before this new column... is your column formated as date ?
Get this new code:
Date.ToText([Column1], "yyyyMMdd")
I missed the upper double M.
It's OK ! Thank you so much !
Expanding on what camargos88 provided, when adding the new column, test for null
if [Date] <> null then Date.ToText ([Date], "yyyymmdd") else "Invalid Date"
