How do I convert to decimal number to date

[sodavid]

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

[martinpohl · Accepted solution]

use

date(timestamp#(ShippingDate, 'YY.YYM.MDD.hhm.mss'),'YYYY/MM/DD') as ShippingDate

Regards

[sodavid]

Excellent! Thanks a mil!😁