Script

[mario-sarkis]

Hey Guyz , 

I need Help here is my Question

i have a field for example

Renuwel Date

5/25/2015

4/31/2015

3/12/2015

i need to calculate the Count of  [Renuwel Date] it is Greater than [Today()]

How can i write this in a set analysis

Thank you,

[datanibbler]

Hi mario,

test this in a textbox on the GUI first. That way you can easily tell whether it works or not.

To do something like this, you need a way to compare this date with the output of the function > Today() <.

If it doesn't just work like that, the DATE#() function should help there - or you re-format your date in the script.

HTH

[robert_mika · Accepted solution]

=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])

BTW:

Duplicate

Script

[maxgro]

=count({<[Renuwel Date] = {">$(=(today()))"} >}[Renuwel Date])

[sunny_talwar]

=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])

Robert_Mika‌

I understand this is a month old post, but I all seeing the highlighted part for the first time. Would you be able to share some information about it?

Thanks,

Sunny

[robert_mika]

Hi sunindia

Should have been:

=count({<[Renuwel Date] = {">$(=Date(today()))"} >}[Renuwel Date])

See here:

Script

But Massimo (below) has even better option

[jagan]

Hi,

Try like below

=Count({<[Renuwel Date] = {">$(=Today())"} >}[Renuwel Date])

Note: [Renuwel Date] and output of Today() should be in the same format.

Regards,

Jagan.

[pratap6699]

=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])