Unanswered

Dates and Times in Power Fx causing Formula Errors!

(0) Share

Report

Posted on by viet561995

Hey everyone,

I'm working on a formula in Power Fx that subtracts the end date from today's date. I'm encountering some data type errors because the NOW() function includes both date and time, causing issues with calculations. Ideally, I'd like to use a function that only considers the date portion.

In my current formula, even though the end date and the result of NOW() show the same date (e.g., 17/6 or 17 Jun), the difference (DATEDIFF) is -1 instead of the expected 0.

Any suggestions on how to tackle this? I'm looking for ways to calculate date only
Thanks in advance for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Hi @viet561995 ,

Try

DateDiff( 'End Date', Today() )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
viet561995 32 on at

Like (0)

Report

Thanks for the suggestion! Unfortunately, I already tried using TODAY() in Power Fx, but it seems that function isn't supported. That's why I was using NOW() instead.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

Hi @viet561995 ,

Today() certainly is supported

I am assuming 'End Date' in your formula is actually a valid date field or value.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
try :
Abs(DateDiff( 'End Date', Today() ))

Was this reply helpful? Yes No
viet561995 32 on at

Like (0)

Report

Thanks for your reply,

In my case, I'm actually working within the model-driven app, not canvas app. in this model driven app, the Power Fx is in preview mode. Im thinking the TODAY() function might not be available in the preview mode yet so i am trying to find another solution.

Additionally, I can confirm that the End Date field in my model-driven app is set up as a date only type field, so it's not storing any time information.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report

@viet561995 ,

That is also a very good thing to post initially - I will have to step away here as I do not use them.

Was this reply helpful? Yes No
CU09102019-0 2 on at

Like (0)

Report

Hello,

please try next solution:

DateDiff('Date Observed', UTCToday())

Was this reply helpful? Yes No