get all rows within specific date

Hello, given the table information below how can I select all the rows that inclued todays date and the rows for the next 30 days based on getdate()?

                [Id] [int] IDENTITY(1,1) NOT NULL,
      [Date] DateTime,
      [Venue] [varchar](150) NULL,
      [Location] [varchar](150) NULL,
      [MoreInfo] text
gogetsomeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
digital_thoughtsConnect With a Mentor Commented:
SELECT * FROM TableName WHERE [Date] BETWEEN GETDATE() AND DATEADD(DAY, 30, GETDATE())
0
All Courses

From novice to tech pro — start learning today.