Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi expert
I have this field 201904 number format and I like to transform this in a date format 'YYYYMM'
I used DATE#, DATE, NUM# but without success
The final result should be 'Apr-19' , Can you help me with this ?
Thanks
did you try like below ?
=Date(Date#('201904','YYYYMM'),'MMM-YY')