Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Pro Dev & ISV
Unanswered

Create Maintenance Log

(3) ShareShare
ReportReport
Posted on by
I’m currently enrolled on the powerup program in video 11, Creating a maintenance Log, on 1 of the columns it asks to enter the following formula

DateDiff(‘Date Observed’,Now(),Timeunit.Days)

Once this formula is entered it isn’t allowing me to save the column I have followed the videos to the letter and have double checked all previous videos and columns. If you would be able to help and provide a solution so I can carry on with the course it would be greatly appreciated.

 
  • jt1024 Profile Picture
    22 on at
    Create Maintenance Log
    Hello I have the same problem,


    But UTCNow is not fixing the problem for me.

    I ended up having to use
    UTCToday()

    My final formula is;
    //
    DateDiff('Date Observed',UTCToday(),TimeUnit.Days)

    Then it would finally let me save.





  • CU04101432-0 Profile Picture
    9 on at
    Create Maintenance Log
    @KeithAtherton
     
    Thanks for that suggestion, it worked for me. 
     
    I'm a little confused though. "Now" was accepted in the Power Fx for the previous column, as it is for the following column ("Issue Age").
     
    How come? Why is it accepted sometimes and not others? What's the difference (in newbie terms) between UTCNow and Now?
     
    Thanks!
  • Suggested answer
    KeithAtherton Profile Picture
    3,690 Most Valuable Professional on at
    Create Maintenance Log
    Hey. I've seen this issue before - try changing Now() to UTCNow().

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

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

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1