Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
How do I convert 20.200.429.105.959 into YYYY/MM/DD which equates 2020/04/29. Any response is very much appreciated.
or alternatively as
Week( [Shipping Date]) as Week,
month( [Delivery Date]) as Month,
year( [Shipping Date]) as Year,
Regards
Samson O'David
use
date(timestamp#(ShippingDate, 'YY.YYM.MDD.hhm.mss'),'YYYY/MM/DD') as ShippingDate
Regards
use
date(timestamp#(ShippingDate, 'YY.YYM.MDD.hhm.mss'),'YYYY/MM/DD') as ShippingDate
Regards
Excellent! Thanks a mil!😁