To obtain a date in the last 30 days using an SQL query, you can use the below query:
select * from [Table] where Cast([ModifiedDate] as date) = Cast(DATEADD(day,-30, getdate()) as date)
1k questions
657 answers
447 comments
193k users
Related Activities
Categories
Most popular tags