Appsheet formula

[Rahul_Sanghavi]

Whats wrong in this formula since its not returning an value.

any(select(ShiftWorking[ShiftWorkingID],and([StartDate]>=[_thisrow].[Production Date],[EndDate]>=[_thisrow].[Production Date],[pressid]=[_thisrow].[press])))

Date is stores in dd/mm/yyyy format in google sheet

[WillowMobileSys]

---

@Rahul_Sanghavi wrote:

and([StartDate]>=[_thisrow].[Production Date],[EndDate]>=[_thisrow].[Production Date]

---

This part is likely the problem.  This means to select a row where "Product Date is less than or = to the Start Date AND Production Date is less than or = to the End Date". 

You probably mean to select a row where "Production date is BETWEEN the Start Date and End Date"?

If so you just need to switch the Start Date operator from ">=" to "<="

If not then please explain, in words, which rows you want to select.