In my SQL server database i have a field called Full_date. It is varchar(8) type.
to use this field in my QV application, i used Convert(date, Full_date) to convert into date data type.
Now, i made a date, month, year fields using the above field.
Month(Fulldate) as Month,
Year(Fulldate) as Year,
Day(Fulldate) as Date
I have created the Pivot table to show the current month sales, Previous month sales, current month target and previous month target.
My selections as below.
First i am selecting the Year, then ;month.
When i select month, the report should should show both current month and previous month sales and target.
When i use code "Month(Num(Month)-1)" is giving "Dec" month on the current selected month is "Feb". Actually it should give month "Jan" as my previous month.
