Quick question, I would like to know who you select the previous month in SQL Server when using a YYYYMM int format.
i.e. I have a date in my date_dim that is 201504 and I want it to become 201503 in my results.
is there a quick method of doing thisd as the only method I currently have is very long winded and will slow my code?
I'm sure this is a simple fix but need some assistance with it...Thanks.