I need to convert time to text value and update database entry (data type: time(7))
A textbox is setup for text input and then a lable is setup to convert text into HH:MM Am/PM format. Setting of the label as below:
At default, the textbox is set at the current time using Now() function.
However the lable is unable to show time when textbox is at default value.
Very apprecaite if you can tell me how I can get the label to reflect value of the textbox when at its default value.
Much thanks in advanced.
I also tried to set for the label to refer to the textbox (tiEndTime)
If( IsBlank( tiEndTime.Text ), Text(Now(), "[$-en-US]HH:MM AM/PM"), Text(TimeValue(tiEndTime.Text), "[$-en-US]hh:mm AM/PM"))
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021