Timestamp to date conversion

[prashantsanchet]

Hi Community,

I have a database column in the form of following. i want to get the date in (MM/DD/YYYY) how we write expression for same

Date_TS

20-Jan-18 05.12.12.000000000 AM

21-Jan-18 05.12.10.000000000 AM

[players9]

=Date(Timestamp#(Date_TS,'MM/DD/YYYY hh:mm:ss[.fff] TT'),'MM/DD/YYYY')