Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Formula 1

Status
Not open for further replies.

JBourne77

IS-IT--Management
Jan 21, 2008
153
US
I would like to populate 'No Last Visit' if {Data.Last Visit Date} = '1900-01-01 00:00:00.000'. Below is my formula that prints a blank, but I need a way to populate this string instead. Any help is appreciated.

Code:
IF {Data.Last Visit Date} = datetime(1900,1,1,0,0,0) then 
datetime(0,0,0,0,0,0) ELSE
{Data.Last Visit Date}

 
IF {Data.Last Visit Date} = datetime(1900,1,1,0,0,0) then
"No Last Visit" ELSE
totext({Data.Last Visit Date},HH:mm, yy MMMM ddd")

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top