Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
From a list of dates, per month, I always want to specify for the next 6 months from today's month how many people move out of a flat.
Currently I use the following formula
= Count ({<month = {"$ (= month (addmonths (today (), 6,1)))"}>} _ Excerpt date)
..with variable value for the months in the future 0,1,2,3,4,5,6
The only problem is that it counts the values of the month of each year.
In the master calendar I have a "unique month" in the form z.Bsp "Sep 2018"
So the formula should compare, except I get the part {"$ (= month (addmonths (today (), 6,1))}} not there, it just returns the month name.
Does somebody has any idea ? Thank you for your help
= Count ({<[Unique month] = {"$ (= month (addmonths (today (), 12,1)))"}>} pdoc3_exclusion date)
Monthname() is what you need I guess. Try with that. If that doesn't help, try to share your sample qvw.