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

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

      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?