0 Replies Latest reply: Aug 6, 2018 11:54 AM by daisy ch RSS

    date format issue?

    daisy ch

      Hi

      I have date field with time stamp.

       

      mydate:

      29/03/2018 22:38:10

      29/03/2018 22:42:19

      29/03/2018 22:44:10

      08/04/2018 09:32:14

      08/04/2018 10:38:19

      08/04/2018 12:39:07

      14/05/2018  08:55:18

      14/05/2018  10:56:16 like that.

       

      my requirement is first i need to create the month field.above date it is available 3 months and each month having multiple date because time stamp.so i need to create only one date instead of 3 dates.like below

       

      Month:

      MAR-2018

      APR-2018

      MAY-2018

      JUN-2018  like that,how to achieve this.

      I am writing the exp in script level for month field like

       

      date(floor(date(mydate,'DD/MM/YYYY hh:mm:ss'),'MMM-YYYY') as month

      after derive the month field i want to create the line chart with rolling 12 months.if i have 4 months how to write the expression.

       

      Thanks