We have an inspection type work order that will not be worked on for 18 months from the creation of the work order. We've been asked to create an Adhoc query/dashboard that shows any work orders due within the 18 months. There does not seem to be an easy way to set a dynamic filter that far in the future. There is the @Next90Days query value, but looking for a spot to add in @Next18Months or @Next540Days or some other range.
Any ideas?
