Forum Discussion

Helper V

6 years ago

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 !

camargos88
6 years ago
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.

Community Champion

6 years ago

Hi Vanessa250919 ,

Try this code on Power Query:

Helper V

6 years ago

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

camargos88
Community Champion
6 years ago
Vanessa250919 ,

It's not a problem, if null it will return null.
- Vanessa250919
  Helper V
  6 years ago
  camargos88 I want say, In the new collumn the date is not correct
  
  05/05/2020 = 20200500
  - camargos88
    Community Champion
    6 years ago
    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.