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
670 answers
451 comments
193k users
Related Activities
Categories
Most popular tags