Get Previous Month From Parameter??

[sconti11]

I need to be able to get the previous month of a parameter.

Here is the code:

MONTH(dateCreated) = @Month

I tried MONTH(dateCreated) = @Month -1

But that does not work.....I thought it would since it works with the @Year prompt.

Any suggestions would be welcome!

 

[PWise]

dateadd(m,-1,@Month )

 

[markros]

If @Month an integer parameter? It would not exactly work (say, if @Month = 1), I suggest to construct dates based on passed month instead.

PluralSight Learning Library

 

[sparkbyte]

You can try playing with this Where clause I use.

Where TrackingDate Between Convert(DATETIME, @DateParam1, 102) -- Date format (2010-05-24 00:00:00.000) AND DateAdd(dd,1,DateAdd(s, -1, Convert(DATETIME, @DateParam2, 102))) -- (2010-05-28 23:59:59.000)

and here is another example I like to use as a reference.

Select
DATEADD(dd, 0, DATEADD(mm, DATEDIFF(mm, 0, CURRENT_TIMESTAMP), 0)),  -- First Day of Month
DATEADD(ss,-1,DATEADD(dd, DATEDIFF(dd, 0, CURRENT_TIMESTAMP), 1))    -- End of Current Day

Hope this helps.

Thanks

John Fuhrman

 

[sconti11]

It works now....not sure why it didn't before, but my original code is working.

Nonetheless, the suggestions in this thread are VERY helpful!