Steve,
Try
if {HPD_Help_Desk.Last Resolved Date} is null then "N/A"
else {HPD_Help_Desk.Last Resolved Date}
Joe
----- Original Message ----
From: Steven Iocco <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Thursday, October 9, 2008 8:02:00 PM
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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
