Count if Date > Variable

[DMG]

Hi, i'm trying to count all dates that are above a date stored in a variable, in my data load statement i have

Let vStartDate=date('01/04/2020');
Let vEndDate=date('01/07/2020');

In my sheet formula, i would then like to count all dates where the date in the field FinalReportDate is >= vStartDate

I've tried various examples on the forum but cant seem to get any to work, whats the correct syntax ?

[PrashantSangle]

try below 

=count({<FinalReportDate={">=$(=vStartDate)"}>}FinalReportDate)

Regards,

Prashant Sangle

[MayilVahanan]

Hi @DMG 

Try like below

Let vStartDate=date(MakeDate(2020,04,01));
Let vEndDate=date(MakeDate(2020,07,01));

In expression,

=count({<FinalReportDate={">=$(=vStartDate)<=$(=vEndDate)"}>}Distinct FinalReportDate)