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!

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

exclude a location from a certain point in time

Status
Not open for further replies.
jschill2628

jschill2628

Programmer
Nov 3, 2009
156
US
I am trying to exclude a location from the criteria is the loss date is greater then a certain date, but there is something wrong with my formula.

else if {?MBO Inclusion Options} = "2" then not ({CHILOC_MBO.LOCATION} in ["NJDN", "MDTO"])
and if {CHILOC.LOCC} = "4623B" and {CHICLAIM.LOSS_DT} > Date (2013, 07, 01) then {CHICLAIM.CLAIM} = "0"
and if {CHILOC_MBO.LOCATION} = "TXSL" and {CHICLAIM.LOSS_DT} > Date (2013, 10, 01) then {CHICLAIM.CLAIM} = "0"

I am on crystal 10

Thanks in advance!
 
Status
Not open for further replies.

Similar threads

Sajeesh Aravind
  • Locked
  • Question
Smooth Line Cure is cutting in Y axis
Replies
1
Views
227
hilfy
hilfy
MH6
  • Locked
  • Question
Example to Run a Crystal Report from an Oracle Stored Procedure?
Replies
3
Views
327
tomcat24
tomcat24
DSenger
  • Locked
  • Question
Developing a Crystal Report in text format
Replies
8
Views
274
kray4660
kray4660
kad123
  • Locked
  • Question
Fixed Length txt file from Crystal Reports (11)
Replies
9
Views
381
kenhamady
kenhamady
hg05
  • Locked
  • Question
Crystal Reports Left outer join and link type
Replies
1
Views
292
PeterDimitrov
PeterDimitrov

Part and Inventory Search

Sponsor

Back
Top