Create Maintenance Log

(3) Share

Report

Posted on by CU-19081616-3

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.

Categories:

Power Apps Pro Dev & ISV

Screenshot 2024-0...

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (2)

Report

Hey. I've seen this issue before - try changing Now() to UTCNow().

Was this reply helpful? Yes No
CU04101432-0 9 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
jt1024 22 on at

Like (0)

Report

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.

Was this reply helpful? Yes No