Forum Discussion
Extract a string of variable length and position from a cell
I have a value in one cell: 1191015. This is a date in Mapics (century-year-month-day). I want to substring this to: 10/15/2019 Thanks!
BeckyC , how to convert Mapics dates to calendar dates is here https://www-01.ibm.com/support/docview.wss?uid=swg21333308
If you Mapics day is in A1 it'll be
=DATE(FLOOR(A1/10000,1) + 1900,FLOOR(MOD(A1, 10000) / 100,1),MOD(A1, 100 ))