Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
check now -
Count({<ListItemsFromID_Proximity_end={">$(=date(Today()))"}>}ListItemsFromID_Proximity_end)
Hi @JoseGarcia
Count({<Proximity_end={">$(=date(Today())"}>}Proximity_end)
Hi @MendyS
it is showing error:
=Count({<Date(ListItemsFromID_Proximity_end)={">$(=date(Today())"}>}ListItemsFromID_Proximity_end)
do I have any mistakes in the syntax?
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
still showing error 😞
Count({<ListItemsFromID_Proximity_end={">$(=date(Today())"}>}ListItemsFromID_Proximity_end)
check now -
Count({<ListItemsFromID_Proximity_end={">$(=date(Today()))"}>}ListItemsFromID_Proximity_end)
success! Thanks a million @MendyS