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

wnicholl's avatar
wnicholl
Resolver II
2 years ago

Thanks for reaching out. I changed the data type to Whole Number in query editor and I'm still getting an error. 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

I cannot help you unless i see the file.

  • wnicholl's avatar
    wnicholl
    Resolver II
    2 years ago

    I'm connected to AS400 so their is no external fime available. I can provide a copy of the data is that helps.  Thank you!