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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: smbrooks0307
- Order by date
-
3rd party output default values
I'm not very good with Crystal reporting. I typed in the following formula for this field: if {CDASSIGN.DATE_CLOSED}=datetime(1753,1,1,0,0,0) then datetime(0,0,0,0,0,0) else {CDASSIGN.DATE_CLOSED} and am still getting DATE_CLOSED 1-Jan-1753 in my output I have also tried: if...- smbrooks0307
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
3rd party output default values
I failed to mention that I am using Crystal Reports XI to extract the data. The "blank" date is coming back with 01/1/1753 12:00:00AM for which I would like to actually write to come back with a blank cell. Thanks!- smbrooks0307
- Post #2
- Forum: Business Objects: Crystal Reports 1 Formulas
-
3rd party output default values
Good morning, I am extracting data from a third party software application and have noticed that the output for a blank value is 01-Jan-1753. I need to write a formula that would take this value and change it to be a blank field and am not sure how to write it. Any help would be greatly...- smbrooks0307
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
