Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
abraham_paradac
Contributor III
Contributor III

Compare Future Expire Date with today in SetAnalisys

Hi, I would like  Know how if posible compare a  Future_Expire_Date >= Date(Today()),  I Making a Count Distinct from a value with 2 conditions:   

 

 Count({$<CONCEPT = {"FEE*", "SALES*"}, (Today())={"<=$(=Future_Expire_Date)"} >} distinct (CONTRACT))

Labels (3)
1 Solution

Accepted Solutions
abraham_paradac
Contributor III
Contributor III
Author

Finally I could solve this problem with this sentence:

 

Count({$<CONCEPT = {"FEE*", "RENT*"}, DATE_EXPIRE_CONTRACT = {">$(=Date(Today(), 'DD/MM/YYYY'))"}>} distinct (CONTRACT))) 

View solution in original post

1 Reply
abraham_paradac
Contributor III
Contributor III
Author

Finally I could solve this problem with this sentence:

 

Count({$<CONCEPT = {"FEE*", "RENT*"}, DATE_EXPIRE_CONTRACT = {">$(=Date(Today(), 'DD/MM/YYYY'))"}>} distinct (CONTRACT)))