Filtering By Date

[EDGARA]

I am querying the database and retrieving many fields one of them being a date field.

I want to be able to list all the records which have a date greater than or equal to {Today} but I am not able to get it to work.

1. I double click on the DataBand
2. I click on filters
3. I have 2 filters which work --- example
a) Left(example.title,3) != "123"
b) example.status != "D"

These two are helping me only list the records which title does not start with "123" AND of which status is not "D".
I want to be able to add a new filter which will let me list the records that have a date that is greater than {Today}

4. Add a filter and select expression
5. I have tried the following things:

a) I enter an expression "example.date >= {Today}" every time i submit this it takes the } off the filter and breaks it
b) I enter a value
Data Type: DateTime
Column: I select the column I want
Option: greater than or equal to

Does not work and breaks it. I have tried all combinations possible and have yet to find a solution please help

[HighAley]

Hello

The better practice is to filter all data in your query. It will speed up the building of report.

If you still want to use filter of Data Band you shouldn't use Braces ({}) in the expression. The braces are used to identify expressions in the text fields.

Thank you.