Forum Discussion
Solved
Converted Date Field (Incorrect Day Showing)
I converted source data field (yyyymmdd) "ACEFDT" using the following formula to create a calculated column to show (mm/dd/yyyy). The calculated column show the year and month as being corrcet, but ...
I was able to resolve my date issue. The below process was used in power query. Thanks again for your insights.
1) Changed source field to TEXT
2) Created a custom column and used M-code // Text.BeforeDelimiter([ACEFDT], " ")) //
3) Changed new column to Date format
The formula is incorrect. Check the last section.
However, this will convert to a date in Power Query simply by changing the type (i.e. without the convoluted formula)
I was able to resolve my date issue. The below process was used in power query. Thanks again for your insights.
1) Changed source field to TEXT
2) Created a custom column and used M-code // Text.BeforeDelimiter([ACEFDT], " ")) //
3) Changed new column to Date format