Filters for all dates

By jdk ·

I am using Between and AND to filter the dates in report what I have specified in two testboxes in relevant form. Its working on that but if I leave the textboxes blank. How will I get all the dates. Its showing error. May be Null value.

Can anybody help me out.

I have more troubles in filters but let u know after I get the solution of this.

Best Regards

Jaidev Khatri

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Three ways

by Tony Hopkinson In reply to Filters for all dates

drop the filter if no dates
provide a default if no date entered
between 01/01/1900 and (31/12/3000) say
beef up the filter
(between stardate and enddate) Or ((startdate is null) or (enddate is null))

Related Discussions

Related Forums