web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps DateDiff Function Error

Power Apps - Building Power Apps

Answered

DateDiff Function Error

Like (0) Share

Report

Report

Posted on 2 Apr 2021 19:05:21 by Phineas

5,106 Super User 2025 Season 2

I am using the following condition in the Text property of a Gallery Label field.

When the Gallery fields are populated with data there is no error (in development view).

When there is no data in the Gallery fields the error (shown below) appears.

Gallery / DaystoRenewalFld / Text Property:

Lookup(DaystoRenewalCollection,ClassTitles=ThisItem.CQTitle).DaystoRenewal - DateDiff((ThisItem.DteofCQ),Today(),Days)

Power Apps Error Message:

"The first argument to the DateDiff function cannot be blank."

Categories:

General Questions

All responses Img

All responses (3)

Answers Img

Answers (1)

Phineas 5,106 Super User 2025 Season 2 on 05 Apr 2021 at 14:36:52

Like (0)

Report

Re: DateDiff Function Error

Sorry, just getting back to this; yes, your recommendation did clear the error message. Thank you.
WarrenBelz 149,147 Most Valuable Professional on 04 Apr 2021 at 23:58:50

Like (1)

Report

Re: DateDiff Function Error

Hi @Phineas ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.
Verified answer

WarrenBelz 149,147 Most Valuable Professional on 02 Apr 2021 at 20:49:40

Like (0)

Report
Re: DateDiff Function Error

@Phineas ,

That is because DatDiff() requires a date to be valid. Try this

If( Value(ThisItem.DteofCQ)>0, Lookup( DaystoRenewalCollection, ClassTitles=ThisItem.CQTitle ).DaystoRenewal - DateDiff( ThisItem.DteofCQ, Today(), Days ), 0 )

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.