3 Replies Latest reply: Sep 1, 2016 12:00 PM by Peter Cammaert RSS

    Using Date#() Function to extract Month, Day, Year

    Angela Perez

      Hello all,

       

      I have a field called "created_at". This field contains a date in YYYY-MM-DD format.

       

      I am trying to extract out the year, month, and day using the Date#() format. I've been using this expression (to try and grab month):

       

      ,Date#(ticket.created_at, 'YYYY-MM-DD') as Extracted_date
      ,Month(Extracted_date) as Month

       

      For some reason this just doesn't seem to be working, am I doing something wrong here?