Date_Add

[RevelationUK]

Im trying to implement the Date_Add function, but im having some problem.

SELECT tblCustomers.*
FROM tblCustomers
WHERE (((tblCustomers.State='No Letters Sent') And (tblCustomers.DateEntered<=Date_Add(Date(),INTERVAL 1 MONTH))

Gives me an error, how do i correct this? I know its a silly syntax mistake, searched and I don't understandt basically

 

[DotNetGnat]

did you mean:

WHERE (((tblCustomers.State='No Letters Sent') And (tblCustomers.DateEntered<=Date_Add(mm,Date(),1))

-DNG

 

[amrita418]

Shouldn't it be?

SELECT tblCustomers.*
FROM tblCustomers
WHERE tblCustomers.State='No Letters Sent' And tblCustomers.DateEntered <= dateadd(mm, 1, getdate())

If you are concerned about the time too then use the convert function like below:

select dateadd(mm, 1, convert(varchar, getdate(), 101))

Regards,
AA