5 Replies Latest reply: Nov 3, 2016 4:05 AM by Aniruddhya Dutta RSS

    Coversion to date from Date time field

    Aniruddhya Dutta

      Hi All,

      I want to convert the below date time field to date

      datetime.PNG

       

      it should give me as 10/21/2016 or 21-Oct-2016

       

      I tried in my expression

       

      date((left(DATETIME,8)),'MM/DD/YYYY')

       

      dayname(DATETIME)

       

      but they don't seem to work.