Forum Discussion

RAKESH1986's avatar
RAKESH1986
Icon for Helper II rankHelper II
3 years ago
Solved

convert text in to date-Two format of dates

Hi All,

i am getting below issue, pls help me to resolve this it

 

I have a date field ..but these have two types of values in excel.. one is proper date format (2/1/2023) and another is text format but a date value  (13-01-2023), neither am I unable to convert this in excel nor in power bi..both are giving problem..

 

pls help me with how to solve this problem.

 

 

when I am converting this in date format, getting the below error.

 

 

 

Need Help
  • ronrsnfld's avatar
    ronrsnfld
    3 years ago

    Try:  Change Type with Locale => Date => English(United Kingdom)

    which will generate this code:

     

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Previous Step", {{"Date", type date}}, "en-GB")
in

     

     

    Change #"Previous Step" to the name of that step if you are using this instead of the UI.

    If that doesn't work, please share

    • the original source (the type of source -- eg CSV File) of the data,
    • a copy/paste of some data from that source (as text, not a screenshot),
    • the M-Code in the advanced editor and
    • your Windows Regional short date settings.

     

1 Reply

  • ronrsnfld's avatar
    ronrsnfld
    Icon for Super User rankSuper User
    3 years ago

    Try:  Change Type with Locale => Date => English(United Kingdom)

    which will generate this code:

     

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Previous Step", {{"Date", type date}}, "en-GB")
in

     

     

    Change #"Previous Step" to the name of that step if you are using this instead of the UI.

    If that doesn't work, please share

    • the original source (the type of source -- eg CSV File) of the data,
    • a copy/paste of some data from that source (as text, not a screenshot),
    • the M-Code in the advanced editor and
    • your Windows Regional short date settings.