Forum Discussion

wnicholl's avatar
wnicholl
Icon for Resolver II rankResolver 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

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

The formula is correct.  In the Query Editor, change the data type to Whole Number.

wnicholl's avatar
wnicholl
Icon for Resolver II rankResolver 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
    Icon for Super User rankSuper User
    2 years ago

    I cannot help you unless i see the file.

    • wnicholl's avatar
      wnicholl
      Icon for Resolver II rankResolver 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!