Help formatting a text formula?
This is what I have so far... Basically just trying to get it to display Date and Time (if there's an end time, "to end time") and then (if there's a description, "- description") Where I'm having ...
Forum Discussion
Try editing the last part to read like this
If(isnull([End Time]),"", "to" & " " & ToText([End Time]))
&" "&
If([Description]="","", "-" & " " & [Description])
I am assuming here that the field [End Time] is a Time Of Day field type. Note that you may not use IsNull( ) for a text field.
If(isnull([End Time]),"", "to" & " " & ToText([End Time]))
&" "&
If([Description]="","", "-" & " " & [Description])
I am assuming here that the field [End Time] is a Time Of Day field type. Note that you may not use IsNull( ) for a text field.