Forum Discussion

112300576's avatar
112300576
New Member
4 years ago
Solved

Date time issues some custom and not custom in same column

  Hi All - I have a date time field from a report - in the report from the system it comes into excel format. The date time field displays dates and times but some read as a custom format in e...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi 112300576 ,

     

    Probably I reproduced your error. 

    Because your Power Query defaults to only recognize the date format of DD/MM/YYYY, but

    the date format of the data source you provide is MM/DD/YYYY.

    The workaround is to use change type with local.

    Data type is Date/Time and locale is English(United States).

    And OK.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi 112300576 ,

 

Probably I reproduced your error. 

Because your Power Query defaults to only recognize the date format of DD/MM/YYYY, but

the date format of the data source you provide is MM/DD/YYYY.

The workaround is to use change type with local.

Data type is Date/Time and locale is English(United States).

And OK.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.