6 Replies Latest reply: Aug 2, 2015 2:30 AM by arjun rao RSS

    How to get YearMonth field from a timestamp

    Baiyang Xiang

      Hi I have a normal time field with date and time. i use

       

      date(floor([Execution Date]),'MMM-YYYY') AS yearmonth

       

      to get the yearmonth. but i still can't aggregate based on that. because I notice in the list box, they show multiple same yearmonth, so the date is still there. how to get rid of date from my yearmonth so that i can calculate based on that. see the picCapture.PNGCapture1.PNG

       

      I guess it is a simple question... maybe it is my way of search but i have not find answers in the forum.

      Thanks for the help!