Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Finally I could solve this problem with this sentence:
Count({$<CONCEPT = {"FEE*", "RENT*"}, DATE_EXPIRE_CONTRACT = {">$(=Date(Today(), 'DD/MM/YYYY'))"}>} distinct (CONTRACT)))
Finally I could solve this problem with this sentence:
Count({$<CONCEPT = {"FEE*", "RENT*"}, DATE_EXPIRE_CONTRACT = {">$(=Date(Today(), 'DD/MM/YYYY'))"}>} distinct (CONTRACT)))