Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a meeting_date field which is includes all post and future meeting dates. I want to show the 'next' meeting date after today?
I have a Max(meeting_date) which shows me the last meeting date booked but I know want to bring in a min after today()? Any ideas? Its DD/MM/YYY format for the UK.
Thanks
use set analysis something like below
count({<meeting_date={">$(=today())"}>}meetingid)
Thanks ... I just want to display the 'Next date', not sure I made that clear.
try
min({<meeting_date={">$(=today())"}>}meeting_date)
Yes and thankyou - worked fine. 😁