SetAnalysis

[Vittore8]

=count({<dateStart={'<=$(=date('01.07.2020')'}, dateEnd={'>=$(=date("01.07.2020")'}}>} CD_ID_DOG)

why it doesn't work???

[Taoufiq_Zarra · Accepted solution]

Syntax Erros, check

=count({<dateStart={"<=$(=date('01.07.2020'))"},dateEnd={">=$(=date('01.07.2020'))"}>}  ID)

[agigliotti]

Hi,

give a try with the below expression:

=count( {< dateStart = {"<=01.07.2020"}, dateEnd = {">=01.07.2020"} >} CD_ID_DOG )

what is the date format of dateStart and dateEnd fields?

[Vittore8]

date