Select records from Last N days in SQL Server

rakibxl

SOLVED CLOSED ACTIVE ANSWERED
User: rakibxl
Posted: on Feb 26, 2020 11:12 PM
Forum: SQL Server
Answer: 1
Views: 1539

I have a one table Called MeetingInfo. In that table there is a info regarding Meeting Start Date and End Date And Metting Room.

I want to make a query by which i want to see all the Meeting start Date and EndDate but From today to 365Days Ago. Below Way i am trying

DECLARE @TodayDATE = GETUTCDATE()
Select * from MeetingInfo 
WHERE StartDate between DATEADD(DAY,-365,GETDATE()) and @Today
AND tbia.EndDate between DATEADD(DAY,-365,GETDATE()) and @Today

What do u think this is the correct way to see the results

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Feb 27, 2020 03:09 AM
Report

Hi rakibxl,

Use below Query.

SELECT * FROM MeetingInfo 
WHERE StartDate BETWEEN DATEADD(DAY,-365,GETDATE()) AND GETDATE()
AND EndDate BETWEEN DATEADD(DAY,-365,GETDATE()) AND GETDATE()

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Select records from Last N days in SQL Server

Company

Explore

Follow us

Contact Us