Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

AutoSearch Date Range based on single input

edited January 2003 in End User
Using RBEnt 6.03 in a D5 application.

Would like to have user enter a single date (i.e. '12/10/03'), and search
two different fields based on that value. It gets better though..

(SQL)
(DateField1 < dateadd(dd,6,UserDate))
AND
((DateField2 between dateadd(dd,-7,UserDate) and dateadd(dd,5,UserDate))
OR DateField2 is null )

The second condition could be simplified to:
isnull(DateField2,UserDate) between dateadd(dd,-7,UserDate) and
dateadd(dd,5,UserDate)

Either way, it gets tricky.

Thanks in advance for any help.

Comments

This discussion has been closed.