Dates between

Databases
1

Hi all.
I need your help with this query (not working):


SELECT DATA 
   FROM _db_m._tbl_m
   WHERE DATA BETWEEN " & DateAdd("d", -10, DATA) & " 
       AND DATA  & DateAdd("d", 0, DATA) & "
ORDER BY DATA DESC

I need see the dates between 2010-08-16 and 2010-08-25.
Can you help me?

Thanks in advance.
ts

2

I’m sorry… I opened a unnecessary thread: :blush:


SELECT _DATE 
   FROM _db_m._tbl_m
      WHERE _DATE BETWEEN 
      DATE_ADD(CURRENT_DATE(), INTERVAL -10 DAY ) 
      AND CURRENT_DATE() 
ORDER BY _DATE DESC

Kind regards-