Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem i can't solve.
I made a tabelobject what show the following information:
- company name
- contract_startdate
- contract_enddate
The function of the tabel is to show when a compony started there contract end when it ends.
My question is: is it possible to create a function where i can put a specifik date, where the tabel reacts by showing only company names were contract_enddate is higher then <inputdate>.
I hope someone can help me?
Regrats,
Rick
Miguel,
I know why this doesn't work.
Our companies have at least 2 contracts.
We test your example above it works.
When we add for example company B 2 times (so 2 contracts) bouth will not be showed.
So the 2the or more contracts caught the problem.
Do you know how we can fix this so only the active contracts will be show also when a company has 1 active contract and 1 contract that has end?
rickvanewijk wrote:Do you know how we can fix this so only the active contracts will be show also when a company has 1 active contract and 1 contract that has end?
Rick,
There may be several solutions:
A) If "Active" is a field that already exists in your database, then use it in the set analysis
Only({< Active = {'Y'}, EndDate = {'>$(=Date(vDate))'} >} EndDate)
B) If the "Active" status depends on the end date itself, then something like the following
Only({< EndDate = {'>$(=Date(vDate))<$(=Date(Today()))'} >} EndDate)
I've used my code above for these new expressions, so you will have to customize them for your needs and field names.
Hope this helps.