8 Replies Latest reply: Nov 18, 2014 2:27 PM by João Henrique Soares

# Using function today () in set analysis?

Good Afternoon,

I wonder how can I use the function analysis on set today?

I need to return in a text object the delinquent amount until the present day.

Ex: sum ({<[Due Date] = {\$ (= Today ())}>} [Pending Value])

• ###### Re: Using function today () in set analysis?

Try as below

sum({<({<[Due Date]={'\$(=\$(=(Today()) )'}>}[Pending Value]))

For untill today you can write as below

sum({<({<[Due Date]<={'\$(=\$(=(Today()) )'}>}[Pending Value]))

• ###### Re: Using function today () in set analysis?

Hello,
tested and did not return anything!

Att,

João Henrique

• ###### Re: Using function today () in set analysis?

HI

Try like this

sum ({<[Due Date] = {"<=\$ (= Today ())"}>} [Pending Value])

And make sure, both [due date] and today() are in same format

Hope it helps

• ###### Re: Using function today () in set analysis?

HI ,

Use this code .

sum ({<[Due Date] = {'\$ (= Today ())'}>} [Pending Value])

Please let me know if there is anything.

• ###### Re: Using function today () in set analysis?

This should work:

sum ({<[Due Date] = {"\$ (= date(Today ()))"}>} [Pending Value])

Regards,

Michael

• ###### Re: Using function today () in set analysis?

Thank you all for the help...

Att,

João Henrique

• ###### Re: Using function today () in set analysis?

Hi Joao,

Have you tried

=Sum({<[Due Date]={'<=\$(=Date(Today()))'}>}[Pending Value])

?

Regards, Janneke.