Link to home
Start Free TrialLog in
Avatar of Ruttensoft
Ruttensoft

asked on

SQL: Add 30 Days.

hello

I am using VB.NET and SQL. I want to have a WHERE, where I can use Today + 30 Days.

until now I have:

Tbl_Back_End > GETDATE()

how can I add 30 days to GETDATE()?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Or try this

WHERE Tbl_Back_End > DateAdd("d", 30, GETDATE())
the "d" syntax would be for ms access, and NOW() instead of GETDATE().
for ms sql server, it would be  like I suggested initially.