Query for filter (1 Viewer)

Rashid

New member
Local time
Today, 16:23
Joined
Sep 6, 2019
Messages
22
Ok sir
I have created a laundry software
I want a query in which i can trace (sort) orders which are to be deliverd after 3 Days
So i can prepare them before expected Date.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:23
Joined
May 7, 2009
Messages
19,169
add criteria to your query:

select * from table1 where [delivery date] =( Date() + 3);"

or

select * from table1 where [delivery date] =DateAdd("d", 3, Date())
 

Rashid

New member
Local time
Today, 16:23
Joined
Sep 6, 2019
Messages
22
Thank lot
 

Users who are viewing this thread

Top Bottom