Please tell me how in MS Access using SQL request to create a request to select dates about today’s date?
For example, there is a table contact. It has a date_nity attribute. And we need to make a request that will bring fields that will be a birthday within the next two days, regarding today’s date. (In general, such as this aircraft in contact)
Answer 1, Authority 100%
select * From [Contacts] Where [Details] IS NOT NULL And dateadd ("yyyy", datediff ("yyyy", [Detament], date ()), [Details]) Between Date () and Dateadd ("D", 2, Date ())
select my_date From mytable Where My_Date & GT; = # 2016-03-30 00: 00: 00 # And my_date & lt; # 2016-04-02 00: 00: 00 #;
Thank you all, but helped me this code:
Where Between Date () and Dateadd (“D”, 2, Date ());