May 08 2019 06:24 AM
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!
May 08 2019 07:27 AM
@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 ))