Answered

Logic to set DateTime variable based on dropdowns

(0) Share

Report

Posted on by elbent

I have a date and time picker that I'm trying to use to set a global variable varStartTime. When PM is selected, I would like to advance the time by 12 hours so that it reflects PM. However, I am experiencing a bug I just cannot wrap my head around. Here is my code in the OnSelect and OnChange of all of the controls:

Set(varStartTime, 
 DateTime(
 Year(DateStart.SelectedDate), 
 Month(DateStart.SelectedDate), 
 Day(DateStart.SelectedDate), 
 If(StartTimeAMPM.Selected.Value = "PM", StartTimeHour.SelectedText.Value + 12, StartTimeHour.SelectedText.Value), 
 StartTimeMinute.SelectedText.Value, 0));

Here is my date and time picker:

Below the time is the global variable in a text box for testing. As you can see, the variable has a PM value, even though the dropdown shows AM. It only happens when the hour field is set to 12. I'm missing something obvious and I've looked at it too long so any help is appreciated. Thanks.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

M_Ali_SZ365 1,110 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @elbent ,
Try This Code
Set(varStartTime, DateTime( Year(DateStart.SelectedDate), Month(DateStart.SelectedDate), Day(DateStart.SelectedDate), If(StartTimeAMPM.Selected.Value = "PM", Value(StartTimeHour.SelectedText.Value) + 12, Value(StartTimeHour.SelectedText.Value)), Value(StartTimeMinute.SelectedText.Value), 0 ) );
If this solution resolves your issue, please consider marking it as accepted. ✅
Warm regards,
Muhammad Ali
elbent 87 on at

Like
a
(1)

Report
Copy link

Link copied!

Unfortunately that didn't solve it. It doesn't seem to be an issue with the values, it's with the logic
Verified answer

M_Ali_SZ365 1,110 on at

Like
a
(1)

Report
Copy link

Link copied!
@elbent
I understand the issue you're facing. It seems that the logic for adjusting the time based on the "AM" or "PM" selection in the dropdown is not working as expected when the hour field is set to 12. To address this, you can modify the logic as follows:
Set(varStartTime, DateTime( Year(DateStart.SelectedDate), Month(DateStart.SelectedDate), Day(DateStart.SelectedDate), If(StartTimeAMPM.Selected.Value = "PM" && Value(StartTimeHour.SelectedText.Value) <> 12, Value(StartTimeHour.SelectedText.Value) + 12, If(StartTimeAMPM.Selected.Value = "AM" && Value(StartTimeHour.SelectedText.Value) = 12, 0, // Special case for 12 AM Value(StartTimeHour.SelectedText.Value) ) ), Value(StartTimeMinute.SelectedText.Value), 0 ) );
This updated code checks if the selected time is "AM" or "PM" and if the hour is 12. If it's "PM," it adds 12 hours to the time, and if it's "AM" and the hour is 12, it sets the hour to 0 to represent 12 AM.
If this solution resolves your issue, please consider marking it as accepted. ✅
Warm regards,
Muhammad Ali
elbent 87 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much, this worked! appreciate it.