topic Re: Next meeting date (after today) as a KPI in App Development

Next meeting date (after today) as a KPI

LordGrim — Tue, 21 Dec 2021 21:30:18 GMT

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

Re: Next meeting date (after today) as a KPI

dplr-rn — Tue, 14 Apr 2020 15:18:20 GMT

use set analysis something like below

count({<meeting_date={">$(=today())"}>}meetingid)

Re: Next meeting date (after today) as a KPI

LordGrim — Tue, 14 Apr 2020 15:23:21 GMT

Thanks ... I just want to display the 'Next date', not sure I made that clear.

Re: Next meeting date (after today) as a KPI

dplr-rn — Tue, 14 Apr 2020 15:35:09 GMT

try

min({<meeting_date={">$(=today())"}>}meeting_date)

Re: Next meeting date (after today) as a KPI

LordGrim — Tue, 14 Apr 2020 15:46:15 GMT

Yes and thankyou - worked fine. 😁