Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Suggested answer

Functions for calculated colums do not work

(1) ShareShare
ReportReport
Posted on by 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:
  • CA1105 Profile Picture
    CA1105 224 on at
    Functions for calculated colums do not work
    Please show the error, without seeing what you are seeing can't help.
  • mleijzer Profile Picture
    mleijzer 18 on at
    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 Profile Picture
    FLMike 31,242 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics