Hi Jeff,

used this in WHERE clause as:

where Qtr >=DATEADD(qq,DATEDIFF(qq,0,GETDATE())-3,0) AND Qtr < DATEADD(dd,DATEDIFF(dd,0,GETDATE())+1,0)

i tried to convert but still getting the error

and getting conversion error :Conversion failed when converting...

Hi Jeff,

"do you want the report headings to auto-magically change based on today's date (whatever it is)?"

is there a way to do it ? I am not sure If possible...

Hi

pietlinden

could you please elaborate a bit, I am not getting 🙁

That's right!!! this table using Primarily for generating report and reports filtered based on YYYYMM column.

I really appreciate the responses and suggestions which makes me think and to...

Thanks for the suggestions

I figured this out finally....

Yearmo IN (select [yyyymm] from table where datediff(month, clndr_dt, getdate())<=11)

🙂

Thanks!

Thanks Arnold:-) I got it !! I was confused before and highlighting in object explorer

I tried this but some how its not working for me am I missing something

if possible can you share the screenshots as well.