Help with max and min date!

[sal07]

Hi everyone,

Iam new here in this community, i want help to separate two values deepens on max and min date.

the expression for max date: (if the date is max then count id)

=count(distinct(if(max(date), id)   

the expression for min date: (if the date is min then count id)

=count(distinct(if(min(date), id)   

Thnx for help

[Kushal_Chawda]

=count({<Date={"$(=Date(max(Date)))"}>}ID)  -> For Max

=count({<Date={"$(=Date(min(Date)))"}>}ID)  -> from Min

[sal07]

Thank you Kushal , but the code dosn't work !

[Anil_Babu_Samineni]

May be the reason date format? What is the date format from your Model

=count({<Date={"$(=Date(max(Date),'YourFormatHere'))"}>}ID)  -> For Max

=count({<Date={"$(=Date(min(Date),'YourFormatHere'))"}>}ID)  -> from Min

[ankur_abhishek]

=count({<Date={"$(=Date(max(Date),'DD/MM/YYYY'))"}>}ID)  -> For Max

=count({<Date={"$(=Date(min(Date),'DD/MM/YYYY'))"}>}ID)  -> from Min