
Hello;
I have an app where employees input time, but sometime they forget to change the dropdown from AM to PM, I have tried a few formulas but none has works so far.
I want the dropdown to change after 12:00 PM to PM and After 12:00 AM to AM
Thanks for your help.
Hi @Sabier ,
Default of the drop-down
If(
Hour(Now())<12,
"AM",
"PM"
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.