SetAnalysis

[Channa]

= if(date(VOYAGE_ARRIVAL_DATE,'DD-MM-YYYY')> date(CONTAINER_DISCHARGE_DATE,'DD-MM-YYYY'), count({<HoursVoyageArrivalToContainerDischarge={">=2"}>} distinct DECLARATION_NO))

i am trying to count based on two conditions , it is not counting 

below is working i tried similar with by DB it give me -
= if(today()> today()-1, count({<HoursVoyageArrivalToContainerDischarge={">=2"}>} distinct DECLARATION_NO))

any help 

[tresB]

Context is important to propose a solution. Could you share your sample app with expected output description?

[pradosh_thakur]

It is not really clear what you want to achieve but if your second expression is working may be you have issue with date format.

Assuming you are using this in a table. If your date field is in string format use date# to convert them into dates first
date#(date_field,date_format)