CODEWITHSUNDEEP
sqldatedatetimesubtraction
endless112
endless112

Reputation: 15

SQL - Subtract Date with Integer

I have a document that has "Delivery Date" and "Days to Deliver" fields I would like to calculate a "Dispatch Date" = "Delivery Date" subtract "Days to Deliver".

Currently I'm trying:

dbo.t0.docduedate-dbo.crd1.daystodeliver`

I am getting a datetime format error for above. Where am I getting this wrong?

Upvotes: 0

Views: 9103

Answers (2)

Matas Vaitkevicius
Matas Vaitkevicius

Reputation: 61459

Assuming that you are using SQL server, you could use SQL function DATEADD().
First parameter is d which stands for day.
Second parameter is how many days you want to add and putting minus (-) in front instead of adding subtracts the value.
Last parameter is initial date itself that you want to be manipulated.
You might need to cast input values to appropriate types - second parameter has to be integer.

SELECT DATEADD(d,-[DaysToDeliver], [DeliveryDate]) AS 'Dispatch Date' FROM [TABLE]

Upvotes: 1

Azar
Azar

Reputation: 1867

Try this

Select Dispatchdate = Dateadd(dd,-daystodeliver,Deliverydate)
from table

Upvotes: 1

Related Questions