Find a date between 2 dates

[ArvinFx]

This is the table:

ID	Machine	Start_date	End_date	code
1	2400	01-Jan-20	22-Jan-20	47
2	2400	05-Dec-19	16-Jan-20	38
3	800	01-Dec-19	31-Dec-19	C03
4	800	01-Jan-20	15-Jan-20	963

I need a query to find the row of 18-jan-20 for machine 2400 , which is ID no 1.

Machine	Start_date	End_date
2400	01-Jan-20	22-Jan-20

[CJ_London]

to clarify what you are asking you want a list of records which were 'running' on the 18th Jan.

to do this you use the between criteria (assuming you are including start and end dates)

SELECT *
FROM myTable
WHERE #01/18/2020# BETWEEN myTable.Start_date and myTable.End_date

note date format needs to be US format of mm/dd/yyyy

[ArvinFx]

thanks it Works