Set analysis with Null count help

[mahitham]

Hi Experts,

Can any one please help me on below syntax.

I have two dates like [Start Date] and [End Date]

Here I need to count null from [Start Date] where [End Date] is less than Todays date.

I have tried this syntax but its not working. Please let me know am I missed any thing in the syntax.

=nullcount({<[End Date]<{today()}>}[Start Date])

Thanks in advance.

[jonathandienst · Accepted solution]

Are your dates valid numeric date type or are they strings? Assuming the former:

=NullCount({<[End Date] = {"<$(=Today())"}>} [Start Date])