I want to make a view of a list to display the upcoming birthdays.
I have a list "Employees":
The column "Birthday" is of type date, the other 4 columns all of type "Calculated (calculation based on other columns)", while the output is of type number.
I made a new view "Upcoming Birthdays", which should show me all birthdays within the next 7 days.
The filter of the view looks as follows:
But as an error I get:
Filter value is not a valid number.
So instead of
[Current month] it expects a number, despite the output type of the column "Current month" being a number. The same error I get for
If I just type there the number 1 (for the current month January) and 13 for the current day, everything works as expected.