Unanswered

DateDiff using Date Pickers suddenly not working (Invalid argument type error)

(0) Share

Report

Posted on by KC-09091536-0

I have a field in which DateDiff is used to calculate the difference between two date pickers to alter the visibility of other fields. It was working just fine until this morning.

I am now getting the 'Incorrect argument type, expecting number' error.

The DateDiff formulas in question is:

DateDiff(DateValue1.SelectedDate, DateValue2.SelectedDate, Days)+1

I would really appreciate if someone could help me solve this problem.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I just tested that exact scenario and its working fine for me. What is the full formula you are using to control the visibility?
KC-09091536-0 43 on at

Like
a
(0)

Report
Copy link

Link copied!

The exact formula is:
If((DateDiff(DataCardValue57.SelectedDate, DataCardValue58.SelectedDate, Days) + 1) >= 5, true, false)
The objective is to make the field visible if the difference between the dates is 5 or more days.
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

The logic is fine as long as both of the Data Cards are pointed at Time/Date fields. The only other issue is that the DataCardValues could be null if a Date hasn't actually been selected in the field.
KC-09091536-0 43 on at

Like
a
(0)

Report
Copy link

Link copied!

I ended up formatting the Selected Dates as numbers and just subtracting them instead of using the DateDiff as this was a prod error and needed to be solved quickly. Thank you for your time.