Date Transformation

[mario-sarkis]

Hey all ,

How can I convert this Date "4/5/2017" into a number ?

Noting that it is a Month/Day/Year in this the number show be "42830"

Thank you

[surendraj · Accepted solution]

num(date#('4/5/2017','MM/DD/YYYY'))

[Anonymous]

Try using the number function. For example num('4/5/2017','####0') and this should give you the number 42859.