This content has been marked as final. Show 4 replies
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