Date between query

**graccess** · 03-18-2014, 07:29 PM

Trying to return values that have action dates(ActionDt) which fall between two dates that are inputted on my form CalendarMgr. ActionDt is the field name in my table and TxtDate0 and TxtDate1 are my date ranges from start to end in my form CalendarMgr. If the user doesn't select a date or only selects one date, I want to return all values that have not been restricted by any selected values, or nulls in this case. Below is my query expression. For now it's returning nothing. Not sure where I'm going wrong with this criteria. Thanks in advance!

[ActionDt] Between [Forms]![frmCalendarMgr]![TxtDate0] And ([Forms]![frmCalendarMgr]![TxtDate1]) Or (IsNull([Forms]![frmCalendarMgr]![TxtDate0])) Or (IsNull([Forms]![frmCalendarMgr]![TxtDate1]))

**June7** · 03-19-2014, 12:38 PM

Try:

[ActionDt] Between [Forms]![frmCalendarMgr]![TxtDate0] And [Forms]![frmCalendarMgr]![TxtDate1]) Or [Forms]![frmCalendarMgr]![TxtDate0] Is Null Or [Forms]![frmCalendarMgr]![TxtDate1] Is Null

**graccess** · 03-19-2014, 02:26 PM

works perfectly, many thanks.

Date between query

Thread Tools

Date between query

Similar Threads

Query for most recent date-and-time when records have multiple times for 1 date

2 date fields, how do I create a query to look for records between those date ranges?

query which run command: select records if date is out of date

Query for quarter end date, depending on current date.

Query Help Please - Criteria: <Date()+90 And >Date() Or: <Date()+90 >[Date Data]

Tags for this Thread

Posting Permissions