Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

calculate weeknumber modeldriven app

(0) ShareShare
ReportReport
Posted on by 6

Hi all,

 

I have a start date for a promotion enitity and I want the start date converted into a weeknumber in another field in my entity called Start Week.

 

So when the user selects a date I want the field Start week to be updated

 

How can I accomplish this ?

 

Best regards

Erik

 

 

Categories:
  • Verified answer
    v-siky-msft Profile Picture
    on at
    Re: calculate weeknumber modeldriven app

    Hi @donsvensen_flow ,

     

    If you want to implement this without any code, please try to use calculated field.

    1. create a new Date field named FirstDay to store the first day of the Year

    2. create a Business rule to set the Default Date of FirstDay field, set the condition that are easy to implement, for example:

    Snipaste_2020-06-01_16-19-27.png

    3. Open Calculation, set the Action as follows:

    Snipaste_2020-06-01_16-22-34.png

    Hope this helps.

    Sik

     

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics