I have a Date getting imported as 08JUN2021 (2charDay+3charMonth+4charYear) and I need to switch it to a Date format that will allow integration in other formulas and logic flows.
So far I have tried these 2 formulas without success:
=DATE(VALUE(RIGHT([WES Evaluable Report Date]@row, 4)), VALUE(VLOOKUP(MID([WES Evaluable Report Date]@row, FIND("", [WES Evaluable Report Date]@row) + 2), [Column56]1:[Column57]12, 2, false)), VALUE(MID([WES Evaluable Report Date]@row, FIND("", [WES Evaluable Report Date]@row), 3)))
(Incorrect Argument)
=DATE(VALUE(RIGHT(LEFT([WES Evaluable Report Date]@row, 9), 4)), INDEX([Column56]1:[Column57]12, MATCH(MID([WES Evaluable Report Date]@row, 3, 3), [Column56]1:[Column57]12)), VALUE(LEFT(LEFT([WES Evaluable Report Date]@row, 9), 2)))
(Invalid Data Type)
Any help is really appreciated it!!