Is there a way to use a date function to pull data from all dates except the past 7 days?
Ex: We want to see all production orders that are in RAF status with a date that is before 7 days ago (we don’t want to see the PBOs in this status from the last 7 days, only before then)
I’m assuming you want to set the filter in GUI, not in code.
Then something like (lessThanDate(-7)) should do the job. The number represents the number of days from the current date.
Hi, Thank you. We tried this and just 7 and both still pulled dates from 2-3 days ago.
I don’t think you’ve just found a bug lessThanDate(); more likely the problem lies somewhere else.
Are you able to filter records by this field at all? For example, try to filter by a specific date.
It does work correctly when inputting a specific date.
I verified it in a simple grid and the function works correctly. And I don’t have enough information to reproduce your particular scenario.
Can you please tell me which form did you add the range to and provide a screenshot of your query ranges (Options > Advanced filter or sort)?
