Good evening!
I have dataverse table which has a date column called "Datum", formatted als Date only.
I was trying to get me a calculated column Year with te Year function, like "Year(Datum)"
But I keep getting errors.
As an alternative I tried "Right(Text(Datum), 4)" but this gives me:
- Invalid number of arguments: 1 provided, 2 expected
- Unexpected characters. The formula contains Error where a closing parenthesis was expected
A simple formula like Now() seems to work but everything just slightly more complicated doesn't work anymore.
Any thoughts?
Thanks in advance!