Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert Integer/ text to Date format

Hello all,   I have from date and to date columns with data as   From date 010318 050625 090524   i want to convert this to date format, when i change directly in power bi it is giving the w...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI Anonymous 

    For your formula, you just need to keep the format of this formula same with your local system.

    For example:

    In my computer, my date format is mm/dd/yyyy

    So I adjust your formula as below:

    FROMDATE1 = MID(MC859A01[FROM DATE],3,2)&"/"&RIGHT(MC859A01[FROM DATE],2)&"/"& LEFT(MC859A01[FROM DATE],2)

    Then change the datatype to date

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

HI Anonymous 

For your formula, you just need to keep the format of this formula same with your local system.

For example:

In my computer, my date format is mm/dd/yyyy

So I adjust your formula as below:

FROMDATE1 = MID(MC859A01[FROM DATE],3,2)&"/"&RIGHT(MC859A01[FROM DATE],2)&"/"& LEFT(MC859A01[FROM DATE],2)

Then change the datatype to date

 

Regards,

Lin