Advertisement

10.09.2007 at 12:51PM PDT, ID: 22882437
[x]
Attachment Details

sql syntax to add days to date field

Asked by ksilvoso in Microsoft Access Database, MS SQL Server, SQL Query Syntax

Tags: sql, add, date, days

I have a database - back end sql, front end acces data project.  I want to add 60 days to the now field:
(dbo.tbdProject.ContractExp >= { fn NOW() })
ThanksStart Free Trial
 
Keywords: sql syntax to add days to date field
Title
1 Using Excel as front-end for SQL Ser…
2 Arrays SQL
3 SQL syntax
4 MS SQL query front end
5 Select statement with SQL
6 SQL syntax Question
 
Loading Advertisement...
 
[+][-]10.09.2007 at 12:55PM PDT, ID: 20044008

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.09.2007 at 12:55PM PDT, ID: 20044010

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Access Database, MS SQL Server, SQL Query Syntax
Tags: sql, add, date, days
Sign Up Now!
Solution Provided By: matthewspatrick
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628