Forum Discussion

freelensia's avatar
freelensia
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Does PQ not support YYYY/MM/DD date format?

Hi,

I know that I can convert a value in date format to YYYY/MM/DD in text format with this code:

NextStep = Table.TransformColumnTypes(Table.TransformColumnTypes(LastStep,{{"Date Column Name", type date}}), {{"Date Column Name", type text}}, "ja-JP"),

However, if I start with YYYY/MM/DD in text format, how can I get it to YYYY/MM/DD in date format?

These formats would be fine as well:

YYYY/M/D

YYYY-MM-DD

YYYY-M-D

I think none of these date formats are supported by PQ, but just to make sure, can anybody confirm?

 

I tried to set Using Locale ja-JP but it shows DD/MM/YYYY or MM/DD/YYYY only,

 

Thanks!

  • Hi freelensia ,

    To get your desired format, you need to change your system data format like YYYY/MM/DD.

    The feature of Using Locale is not working as your expected. That works for the text format which is not easy to indentifed as date type in power bi.

    Best  Regards,

    Cherry

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar

    Hi freelensia ,

    To get your desired format, you need to change your system data format like YYYY/MM/DD.

    The feature of Using Locale is not working as your expected. That works for the text format which is not easy to indentifed as date type in power bi.

    Best  Regards,

    Cherry