topic Re: Compare Future Expire Date with today in SetAnalisys in App Development

Compare Future Expire Date with today in SetAnalisys

abraham_paradac — Sat, 16 Nov 2024 06:43:55 GMT

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))

abraham_paradac — Tue, 29 Jan 2019 20:14:58 GMT

Finally I could solve this problem with this sentence:

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