I would like to create a formula that shows the time portion of a date/time field or if empty “none”. I have created two formulas
Formula 1- Named: @orginal value
· TimeValue ({vAuditPunchRpt.OriginalValue})
· This works fine
Formula 2:
· If {@Orginal Value}= Time (0,0,0)then "None" else {@Orginal Value}
· Partially works if I don’t have the “else {@Orginal Value}”