Count date greater than today

[JoseGarcia]

Hi, 
I'd like to count risks that where proximity end is greater than today. 
Using syntax below, but it is not returning correct value.

If(Proximity_end<today(), Count(Proximity_end))

Any ideas?

Thanks

[MendyS]

 Hi @JoseGarcia 

Count({<Proximity_end={">$(=date(Today())"}>}Proximity_end)

[JoseGarcia]

Hi @MendyS 

it is showing error:

=Count({<Date(ListItemsFromID_Proximity_end)={">$(=date(Today())"}>}ListItemsFromID_Proximity_end)

do I have any mistakes in the syntax?

[MendyS]

Hi @JoseGarcia 

I forgot to edit before the post, 

I edit the formula now,

please check again and let me know if its works well  

[JoseGarcia]

@MendyS 

still showing error 😞

Count({<ListItemsFromID_Proximity_end={">$(=date(Today())"}>}ListItemsFromID_Proximity_end)

[MendyS · Accepted solution]

@JoseGarcia 

check now - 

Count({<ListItemsFromID_Proximity_end={">$(=date(Today()))"}>}ListItemsFromID_Proximity_end)

[MendyS · Accepted solution]

Count({<ListItemsFromID_Proximity_end={">$(=date(Today()))"}>}ListItemsFromID_Proximity_end)

[JoseGarcia]

success! Thanks a million @MendyS