Change date format to M/DD/YYYY

[Purushothaman]

Hi Experts,

How to convert the below Data and Time stamp into M/DD/YYYY. 

Please help. Thank you

[vinieme12 · Accepted solution]

as below

date(floor(timestamp#(ACCOUNTOPENDATE,'YYYY-MM-DD hh:mm:ss[.fff]')),'M/DD/YYYY') as Datefield

[Purushothaman · Accepted solution]

Another Solution will be:
If the field  type is Timestamp, then as below:

Date(Floor(ACCOUNTOPENDATE)) as ACCOUNTOPENDATE