Date remove delimiter

[Vanessa250919]

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 ! 

[camargos88]

Hi @Vanessa250919 ,

Try this code on Power Query:

[Vanessa250919]

@camargos88 Thank you, I just try but i have a null data.

[camargos88]

@Vanessa250919 ,

It's not a problem, if null it will return null.

[Vanessa250919]

@camargos88  I want say, In the new collumn the date is not correct 

05/05/2020 = 20200500

[camargos88 · Accepted solution]

@Vanessa250919 ,

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.

[Vanessa250919]

It's OK ! Thank you so much ! 

[blopez11]

Expanding on what @camargos88  provided, when adding the new column, test for null

if [Date] <> null then Date.ToText ([Date], "yyyymmdd") else "Invalid Date"