5 Replies Latest reply: Mar 18, 2018 3:53 PM by omar bensalem RSS

    converting date field DD TO MM

    ravi kumar

      Hi,

      I want to convert MONTH field -> DATE field

      1. Based on date field DD/MM/YYYY(presentDATA)-> YYMM (requiredDATA).
      2. after completing converstion not required to repet .

      * NOTE: Converting DD into MM

      DD/MM/YYYY(PRESENTDATA)YYMM(REQUIREDDATA)
      01/01/20161601
      02/01/20161602
      03/01/20161603
      01/02/2016

      02/02/2016

      03/02/2016

       

      I'm tried like this

      DATE(DATEFIELD,'DD/MM/YYYY') INTO DATE(DATEFIELD,'YYMM')

      its not working.

       

      Thanks,

      Ravi