CODEWITHSUNDEEP
sql-server
user3894022
user3894022

Reputation: 11

Date search range previous month to current month

I had a working SQL date search... (DATEADD (dd,-30, getdate()) <= pymnt_pstd_dt)

it gives me data from the past 30 days, but what I actually need is a comparison of the previous month MTD with the current month MTD

I am currently struggling with a good way to write that for SQL

Any help would be appreciated.

Upvotes: 0

Views: 203

Answers (1)

Dave.Gugg
Dave.Gugg

Reputation: 6771

Here are WHERE statements that will get month to date and previous month to date for your field, pymnt_pstd_dt:

WHERE pymnt_pstd_dt BETWEEN DATEADD(month,DATEDIFF(MONTH,0,GETDATE()),0) AND GETDATE() --Month to date

WHERE pymnt_pstd_dt BETWEEN  DATEADD(month,DATEDIFF(MONTH,0,GETDATE())-1,0) AND DATEADD(MONTH,-1,GETDATE()) --Previous month to date

Upvotes: 0

Related Questions