The value ' : ' cannot be converted to a date or time value.

(0) Share

Report

Posted on by Breitner_Hdez

Dears !

Please, need help with this error... when open App; show it:

(DateDiff(
 DateTimeValue(DateValue1.SelectedDate & " " & HourValue1.Selected.Value & ":" & MinuteValue1.Selected.Value),
 (DateValue2.SelectedDate & " " & HourValue2.Selected.Value & ":" & MinuteValue2.Selected.Value),
 TimeUnit.Minutes
)

Any idea for fix the error? please!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I could only get this error when the selectable fields are blank.
This error should resolve when your controls have selected values.
To avoid having it display this error on launch, the first solution in my mind would be to make this a variable, and only create it when all of these controls have values. Not certain that's the most efficient way to do this however.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Breitner_Hdez,

Have you solved your peoblem?

The way you format the date time is not ideal, generally we format a date time using the following formula:

DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)

So, I suggest you modify your formula as below:

DateDiff( DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0), DateValue2.SelectedDate + Time(Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0), TimeUnit.Minutes )

Was this reply helpful? Yes No
Breitner_Hdez 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Qi.

U code work perfectly. Thx u Crack!

Was this reply helpful? Yes No