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"))
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.