Thanks Meilissa and Joe, this works.
Date: Thu, 9 Oct 2008 19:49:35 -0500From: [EMAIL PROTECTED]: Re: Crystal
QuestionTo: [EMAIL PROTECTED] 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 [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 -0500From: [EMAIL PROTECTED]: Re: Crystal
QuestionTo: [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 [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.cheerssteve __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___ __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"
