I believe the DATEPARSE function will work if you change the months in the format part of the equation to a capital "M". I am not sure why this is giving you an issue-- maybe someone else who understands date formats better can chime in?
I noticed on this page about the function all the times months was used it was a capital M.
I downloaded your workbook and it works for me. Please let me know if you have any questions.
My calculated field is: DATEPARSE("yyyyMMdd", str([Order Received Date Key])).
That makes sense now I look at it as the small m was being interpreted as minutes hence the month showing in the minutes. Weird but at least logical to some extent.
Manager, Wholesale Analytics
Tel: 708.884.2029 | Fax: 630.850.1874
Follett Higher Education Group
Three Westbrook Corporate Center, Suite 200
Westchester, Illinois 60154
image003.png 5.1 KB
3 of 3 people found this helpful
Please find the formula that I have used to solve your problem.
MAKEDATE(INT(LEFT([Order Received Date Key],4)),
INT(MID([Order Received Date Key],5,2)),
INT(RIGHT([Order Received Date Key],2)))
Make date takes the input as the in year, month, date format.
Please refer to the below screenshot.
I hope this would help you. Let me know if you still have any questions about this.
If you liked it then please like the comment and click on That helped.