sql query two dates between 90 days and 7 days

venkycool · Post by **venkycool** » Fri Dec 12, 2008 8:18 am

Hi All,

I am trying to take the result from DW table where I need the record count between last 90 days to last 7 days.

I am trying with this query and am getting the result, but I dont know I am doing the correct one.

My query is SELECT count(1) from table name WHERE etl_timestamp between getdate()-90 and getdate()+7.

Can anyone let me know the query for the above?

Thanks in Advance!

chulett · Post by **chulett** » Fri Dec 12, 2008 8:37 am

Do we have to guess what database?

I would assume your "+7" needs to be "-7".

venkycool · Post by **venkycool** » Fri Dec 12, 2008 9:08 am

Typo!! I am sorry, it is -7. So the query which am using is correct?

SELECT count(1) from table name WHERE etl_timestamp between getdate()-90 and getdate()-7

chulett · Post by **chulett** » Fri Dec 12, 2008 9:13 am

Probably. Change "select count" to "select *" to check. Add a "not" before the "between" as an additional check of what is being excluded.

venkycool · Post by **venkycool** » Fri Dec 12, 2008 9:23 am

Perfect! Saw the difference, query is correct and I got the record count as needed. Thanks chulett!!!