I'm converting a Time string to time on my report. What I would like to happen when there is not a time listed on the database is that it return a blank space in the time field on the report, however, I'm not sure how to return this.
The following is the formula I'm currently using, which returns 12:00:00 when there is no date on the database, due to the CTime(0,0,0)
If IsTime({CallLog.EmailReturnTime}) Then
CTime({CallLog.EmailReturnTime})
Else
CTime(0,0,0)
Any suggestions on how to return a blank on my report?
Thank you in advance for your assistance.