topic Re: Today(1) in "set modifier" in App Development

Today(1) in "set modifier"

Anonymous — Wed, 22 Nov 2017 09:37:51 GMT

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?

Re: Today(1) in "set modifier"

shraddha_g — Wed, 22 Nov 2017 09:39:56 GMT

Try

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

Re: Today(1) in "set modifier"

Anonymous — Wed, 22 Nov 2017 09:50:07 GMT

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 :

Re: Today(1) in "set modifier"

jonathandienst — Wed, 22 Nov 2017 09:55:51 GMT

As above, with bold change

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

Re: Today(1) in "set modifier"

pradosh_thakur — Wed, 22 Nov 2017 09:57:52 GMT

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

Re: Today(1) in "set modifier"

Anonymous — Wed, 22 Nov 2017 10:10:24 GMT

The same result as shraddha.g

Re: Today(1) in "set modifier"

Anonymous — Wed, 22 Nov 2017 10:11:27 GMT

today(1) returns 22/11/2017

Re: Today(1) in "set modifier"

shraddha_g — Wed, 22 Nov 2017 10:16:08 GMT

try,

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

Re: Today(1) in "set modifier"

Anonymous — Wed, 22 Nov 2017 10:56:19 GMT

Same result

Re: Today(1) in "set modifier"

shraddha_g — Wed, 22 Nov 2017 11:03:14 GMT

Try

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

Re: Today(1) in "set modifier"

Anonymous — Wed, 22 Nov 2017 11:19:10 GMT

Damn, You win

It works fine !!

How did you go to the conclusion to use the "floor"?