1 Reply Latest reply: Feb 24, 2018 4:53 AM by omar bensalem RSS

    Date from Timestamp()

    bhavani b

      Hi Experts,

       

      Can any one please help me on this.

      I have a date field like below in Time stamp format.

      How to extract the Date, Quarter and Monthyear from below field.

       

      Date.png

      Thanks in advance

        • Re: Date from Timestamp()
          omar bensalem

          load dateField , (Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,

          'Q' & ceil(month(dateField)/3) as Quarter;

          load date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;

          load * Inline [

          timestampField

          04/12/2017 11:57

          04/12/2017 14:40

          07/12/2017 12:58

          08/01/2018 17:22

          08/11/2017 13:24

          10/11/2017 14:25

          11/12/2017 16:00

          ];

           

          Result:

          Capture.PNG