Forum Discussion

MattMatt1's avatar
MattMatt1
Qrew Trainee
8 years ago

Cannot figure out syntax to display a time of day in a formula text field

So I have a time of day formula that I am trying to put into a formula text field in my form. Here is the formula that I have written. If([Lockbox Needed?]="Yes", "Contract signing scheduled for "&...
LisaSell1's avatar
LisaSell1
Qrew Trainee
8 years ago
I useda Time of Day type field, the times display as AM or PM, and this worked to only show the HHMM in your statement:

If([Lockbox Needed?]="Yes", 
"Contract signing scheduled for "& 
Trim(Left(ToText([Time of day]),5)) &". Also make sure to install lockbox", 
Trim(Left(ToText([Time of day]),5)))