Between Dates

Topic

New Reply

Using this criteria –Between[Enter Begin Date:] And [Enter End Date:] –you have to enter Start and End Date which is what we want most of the time, But sometimes we want all the dates so we just hit Enter when it ask for the Begin Date and Enter when it ask for the End Date but this does not work. We don’t always know the Start Year or date.

Reply | Quote

Replies

You could use

(>=[Enter Begin Date:] Or [Enter Begin Date:] Is Null) And (<=[Enter End Date:] Or [Enter End Date:] Is Null)

Reply | Quote