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 "&...
DavidHawe's avatar
DavidHawe
Qrew Trainee
8 years ago
I don't see where you can use Time of Day with ToFormattedText.  The HHMM format looks like it meant for "Duration" fields.

You may wan to consider using a Date/Time field rather than Time of Day with this:

ToFormattedText([Date Created],"MMDDYY")  returns "01-30-00 10:34 PM