6 Replies Latest reply: Jul 19, 2017 9:41 AM by Sunny Talwar RSS

    Timestamp removal from Date

    Satish Kamath

      Hi All

       

      I have been trying to remove Timestamp from Date field with following syntax

       

      Date(OVESCO_ADD_DATE, 'MM/DD/YYYY') As OVESCO_ADD_DATE,
      DATE(FLOOR(Timestamp#(OVESCO_ADD_DATE)),'MM/DD/YYYY') As OVESCO_ADD_DATE,
      Date(Floor(TimeStamp#(OVESCO_ADD_DATE))) As OVESCO_ADD_DATE,
      Date(TimeStamp#(OVESCO_ADD_DATE,'MM/DD/YYYY HH:MM:SS'),'MM/DD/YYYY') As OVESCO_ADD_DATE,
      Date(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS'),'MM/DD/YYYY') as OVESCO_ADD_DATE,

      Result is either blank column or duplicate values(MM/DD/YYYY format) in List box.

       

      All I want is this date value in MM/DD/YYYY format

       

      Thanks

      Satish