How to change field format from MDYYX to YYMD? There are ways how to do it in other way, but I have not found the way how to do it in this way. Can somebody help?

This message has been edited. Last edited by: Gints,

Do you mean this?

-SET &Date1 = 'October 26, 2020';
-SET &Date2 = DATECVT(DTADD('&Date1', DAY, 0), 'MDYY', 'A8YYMD');
-TYPE &Date1 --> &Date2

Thanks it works as needed!