Forum Discussion

wnicholl's avatar
wnicholl
Resolver II
2 years ago
Solved

Date Field and Calculated Column

Hello,   I'm currently using a calculated column to convert this date 20060523 (text field) to 05/23/2006.   My calculated column is Effective Date = DATE(LEFT('APPDATP (NB)'[QEFDT],4),MID('APPD...
Need Help
  • wnicholl's avatar
    wnicholl
    2 years ago

    I was able to resolve the problem using the folloing steps.

    1) Open power query
    2) Create a custom query
    3) Add the following M Code = Text.BeforeDelimiter([Date Field], " ")
    4) Change type to Date/Calender and Rename Field
    5) Close and Save

gadielsolis's avatar
gadielsolis
Resolver III
2 years ago

Please check if there's a typo, I just tried in my PC and it's working.