When I create a filter within the ad-hoc editor I can filter against relative dates (e.g. db_datefield < DAY+1). I would like to apply such a relative date filter in the ad-hoc prefilter setup ... but it seems as if it does not accept relative dates there. Do I oversee something? Relative dates would make a lot of sense in the prefilter.
Did you mean adding relative date filters in Domain designer? We had this problem before and we eventually solved it this way:
Lets say, if you would like to prefilter db_datefield < DAY+1
1. Go to Domain Deisigner > Calculated field
2. Create a new cal field
- Field name: name of your calculated field.
- Type: Date
- Expression: Today(+1)
3. After that you would see a constant field created.
4. Now go to pre-filter tab. ctrl+click the two date you want to compare(db_datefield and the constant field just created) and pick the right operand.