Hi

I need to be able to filter a records according to the following:

1. Have a start date in every record and an end date.
2. Have Years and months in every record.
3. IncMonth(StartDate,((Years*12)+Months))
4. Convert Date from dd/MM/yyyy to yyyy-MM-dd

Now the filter must be when StartDate with all calculations <> EndDate.

Is it possible filter record on condition calculations per record?

Thanks

Petrus

Petrus


If you can do it with sql there's a very good chance you can do it with a filter. The other alternatives are to use the OnFilter event (very slow) or write a custom function.

My bet would be on the SQL - you just need someone a bit better than me to write it

Roy Lambert