News and Announcements icon

Power Platform CommunityForums Microsoft Dataverse Functions for calculat...

Microsoft Dataverse

Suggested answer

Functions for calculated colums do not work

(1) Share

Report

Report

Posted on by mleijzer

18

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!

Categories:

All responses Img

All responses (3)

Answers Img

Answers (0)

CA1105 101 on at

Like (0)

Report

Functions for calculated colums do not work

Please show the error, without seeing what you are seeing can't help.
mleijzer 18 on at

Like (0)

Report

Functions for calculated colums do not work

OK, I'll try again.

Mijn goal is just to get the year out of this date field "Datum".

Since the Year function gave me errors, I was trying alternative ways to get the desired output.

But it just seems like everything I do gives me the two errors I described above.

I've been googling it and also I tried Chat GPT, which gave me a lot of alternative ways, but somehow I can't get it to work.

So I have a Date field which is configured as date only. Out of this feeld I need a calculated column which extracts the year.
Suggested answer

FLMike 23,258 on at

Like (0)

Report

Functions for calculated colums do not work

HI,

It helps to express what you need and then complete the thoughts fully.

You said "but I keep getting errors", isn't really helpful in helping you.

Show us the error you get, not typed words please, and we can help.

As for your Right(Text(Datum), 4)

I am suprised you are getting that error actually instead of an argument, so I would need to see a picture of what you are typing in.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 140,719

#2

RandyHayes 76,308

#3

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans