Custom Date Values for condition builder?

[brnunn]

Hey All,

Hoping there is a simple solution to this.

So we all love the condition builder - and for date/time queries, you get a plethora of options to choose from. I.e. Tomorrow, Today, Next Month, Last Month etc.  

But despite all the choices, it will never be 'enough' to capture all the needs for everyone - so there has to be a way to create custom ones? For examlple, we have a lot of need for 60-90 day lead time on certain end date reporting. (Appointment administration record keeping). The problem is that there isn't a value for 'Next two months' or 'Next 3 months' - the best is "Next Quarter" but that will not always be a static 2 months, yeah?  

So how do we go about adding in our own values to compare against? This is of course most helpful in static queries that appear in scheduld reports. The only alternative is to pick a date manually, and then adjust that before the reports go out, but that's obviously a terrible solution.  

Any help is appreciated as I haven't found any documentation on this.  

[sowmya123 · Accepted solution]

Have you tried creating a filter with relative on or after? Eg: Created - field name, "relative" - condition, " on or after" , "2 months from now"

[brnunn]

Fantastic - glad to see it was an easy answer. Though I feel silly for having not explored that operator before!

Thanks very much!

[ajinkyaavachat1]

You can try to use Relative filter. You can use options like on or after, on or before, after, before, on along with different duration units.

Found this discussion in community, this might be helpful.

Reporting - relative filter

[brnunn]

Thanks!