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)
922 questions
619 answers
427 comments
190k users
Related Activities
Categories
Most popular tags