if isnull({HPD_Help_Desk_Work_Info.Last_Resolved_Date}) then "N/A"
else cstr({HPD_Help_Desk_Work_Info.Last_Resolved_Date})This works for me. I added the cstr to the else statement. Steven Iocco <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 10/09/2008 07:18 PM Please respond to [email protected] To [email protected] cc Subject Re: Crystal Question ** Hi, yes I have. I get an error saying "a string is required here" and highlights the {HPD_Help_Desk.Last Resolved Date} after the else. Thanks Date: Thu, 9 Oct 2008 19:12:15 -0500 From: [EMAIL PROTECTED] Subject: Re: Crystal Question To: [email protected] ** Can you try the is null function? if isnull({HPD_HelpDesk.LastResolveDate}) then "N/A' else {HPD_Help_Desk.Last Resolved Date} Steven Iocco <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 10/09/2008 07:06 PM Please respond to [email protected] To [email protected] cc Subject Crystal Question ** Hi folks, this should be a no brainer but I cannot wrap my head around it. Trying to do a formula to put "N/A" in a field on my report if the last resolved date is null. Here is my formula if {HPD_Help_Desk.Last Resolved Date}="" then "N/A" else {HPD_Help_Desk.Last Resolved Date} It returns "A date-time is required here" error. Any ideas? this is with crystal 9, or crystal 11. cheers steve __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
