CODEWITHSUNDEEP
sqlsql-server
user9399808
user9399808

Reputation:

Get the DueDate if the date is today

I am assigned to create an alert that if today is the duedate of an item, then the alert will be sent to the team.

I am trying to check how I can filter the where clause of my code:

SELECT     dbo.salesorder.customerid, 
           dbo.salesorder.entrydate, 
           dbo.salesorder.salesorderno, 
           dbo.salesorderdetails.itemno, 
           dbo.salesorder.usercreated, 
           dbo.salesorder.duedate
from       dbo.salesorder 
inner JOIN dbo.salesorderdetails 
ON         dbo.salesorder.salesorderid = dbo.salesorderdetails.salesorderid
where     (dbo.salesorder.customerid = 238)

See image below

If today is 4th of May, I just my report to display the below-highlighted sales orders.

Upvotes: 1

Views: 41

Answers (2)

DxTx
DxTx

Reputation: 3377

SELECT     dbo.salesorder.customerid, 
           dbo.salesorder.entrydate, 
           dbo.salesorder.salesorderno, 
           dbo.salesorderdetails.itemno, 
           dbo.salesorder.usercreated, 
           dbo.salesorder.duedate
from       dbo.salesorder 
inner JOIN dbo.salesorderdetails 
ON         dbo.salesorder.salesorderid = dbo.salesorderdetails.salesorderid
where      dbo.salesorder.duedate = CAST(GETDATE() AS DATE) --or CAST(CURRENT_TIMESTAMP AS DATE) 
           and dbo.salesorder.customerid = 238

Upvotes: 1

Squirrel
Squirrel

Reputation: 24813

convert getdate() to date and compare with the duedate

where     (dbo.salesorder.customerid = 238)
and       dbo.salesorder.duedate = convert(date, getdate())

Upvotes: 1

Related Questions