I have a date field in MDY number format.I want to convert it to YYMD format.How can I do that? for example 40218 (April 2018) to 2018/04/02
Is there a function.

Can somebody help me.

Thanks

This message has been edited. Last edited by: FP Mod Chuck,

So you're missing the Century in your original field? Is it possible you'll have a date from 1900's or are they all from 2000's?