I am building my report to display data that I want to limit using a variable field.
I have a start date field that I only want reported if the date is more than 18 months ago. in effect it will report all historic sales agents that have not made a sale in a long time or never made a sale at all.
Is it possible to have calculated data as a limitation?
I am trying to use the calculated value as: date(today()-495,'DD-MM-YYYY')
Solved! Go to Solution.
Is there no way that this can be achieved on the criteria for the selection in the table that I am trying to produce?
The results are going into a flat table instead of something that is graphically displayed to allow our staff the ability to see if there are sales agents who either have not made a sale or the date of the last sale was greater than the time required.
I have used a custom script to load the dates and filter the data to what I want with your help above, however, it is duplicating rows on my table.
I know the cause, it's an incomplete sale that was never really begun so the data started is missing.
I am trying to remove it using the following but it returns no data:
Managed to figure it out, the IF criteria was wrong and should have been:
thank you for your help shraddha.g