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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
the "d" syntax would be for ms access, and NOW() instead of GETDATE().
for ms sql server, it would be like I suggested initially.
for ms sql server, it would be like I suggested initially.
WHERE Tbl_Back_End > DateAdd("d", 30, GETDATE())