4 Replies Latest reply: May 7, 2012 6:45 AM by jonathan dienst RSS

    How to custom the month, year??

    Gerard Carvalho

      I have attached a qv application. It will have data received as a date column and i have below query to get year, day and month.

      year([Date Received]) as year,

      day([Date Received]) as day

      ,Month([Date Received]) AS Month


      Now the main thing i need is a new field month which should satisfy the below thing , whenver i include month as a list box it should show the jan month to current month.






      forFebruary 2012 you would pull January 2012 and February 2012 YTD info

      forMarch 2012 you would pull Jan 2012, Feb 2012 and Mar 2012 YTD info