Skip to Content
0
Former Member
Jul 18, 2008 at 02:39 AM

How to return blank space in time section of report when empty on database

22 Views

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.