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)
1.1k questions
681 answers
464 comments
193k users
Related Activities
Categories
Most popular tags