Hello,
I have an American date format in an excel file that needs to be uploaded into MYOB Adv. The format is like so ‘20231231’ (i.e. YYYMMDD). How can I convert this to an AUD format in the Import Scenario?
Regards,
Laura
Hello,
I have an American date format in an excel file that needs to be uploaded into MYOB Adv. The format is like so ‘20231231’ (i.e. YYYMMDD). How can I convert this to an AUD format in the Import Scenario?
Regards,
Laura
Best answer by Naveen Boga
Hi
Since the BATCH_EXPIRTY date is in the format YYYYMMDD, I created a formula accordingly and it is working as expected.
Here is the formula:
=CDate(Substring( [BATCH_EXPIRY], 4, 2) + '/' + Substring( [BATCH_EXPIRY], 6, 2) + '/' + Substring( [BATCH_EXPIRY], 0, 4))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.