Today(1) in "set modifier"

[Anonymous]

Hello,

I've got an issue I can't explain.

I use a set modifier to filter on the today date.

This works fine (with the good date)

=Count( {$< [Code contrat]={'SISU*'},  [Date fermeture.autoCalendar.Date] = {'22/11/2017'} > } [N°]  )

This doesn't work (when I wqnt to select the date of the day)

=Count( {$< [Code contrat]={'SISU*'},  [Date fermeture.autoCalendar.Date] = today(1) > } [N°]  )

I've got the message "Erreur dans l'expresssion" (in french) : "Error in expression"

What I am missing?

[shraddha_g]

Try

Count( {$< [Code contrat]={'SISU*'},  [Date fermeture.autoCalendar.Date] = {$(=today(1))} > } [N°]  )

[Anonymous]

Hello,

Thank you for you quick reply.

The error disapeared, but it doesn't return a result in my KPI object:

When I "harded code" the date string

=Count( {$< [Code contrat]={'SISU*'},  [Date fermeture.autoCalendar.Date] = {'22/11/2017'} > } [N°]  )

, I've got this result :

[jonathandienst]

As above, with bold change

Count({$<[Code contrat] = {'SISU*'}, [Date fermeture.autoCalendar.Date] = {$(=Date(today(1), 'dd/MM/yyyy'))}>} [N°])

[pradosh_thakur]

try today(1) in a text box and check the format you are getting. is it DD/MM/YYYY OR MM/DD/YYYY that could be the problem .Make sure it is in DD/MM/YYYY format by using date function.

regards

Pradosh

[Anonymous]

The same result as shraddha.g

[Anonymous]

today(1) returns 22/11/2017

[shraddha_g]

try,

Count( {$< [Code contrat]={'SISU*'},  [Date fermeture.autoCalendar.Date] = {$(=date(today(1),'DD/MM/YYYY'))} > } [N°]

[Anonymous]

Same result

[shraddha_g · Accepted solution]

Try

Count( {$< [Code contrat]={'SISU*'},  [Date fermeture.autoCalendar.Date] = {"$(=date(floor(today(1)),'DD/MM/YYYY'))"} > } [N°] )