AnsweredAssumed Answered

Using a date field in a If statement

Question asked by tcwaters on Dec 7, 2011
Latest reply on Dec 8, 2011 by tcwaters

Can you please show me what I am doing wrong here. I have a calc that is used to populate a field when data is imported. Field = "Degree"

 

Case ( cdegrcode = 1 ; "AA" ;

cdegrcode = 2 ; "AS" ;

cdegrcode = 3 ; "BA" ;

cdegrcode = 4 ; "OTHER BACHELORS" ;

cdegrcode = 5 ; "BS" ;

cdegrcode = 6 ; "CERTIFICATE" ;

cdegrcode = 7 ; "DOC CHIROPRACTIC" ;

cdegrcode = 8 ; "DOC OF OESTEOPATHIC SCIENCES" ;

cdegrcode = 9 ; "OTHER DOCTORATE" ;

cdegrcode = 10 ; "DOC DENTISTRY ";

cdegrcode = 11 ; "DOC VET" ;

cdegrcode = 12 ; "JD" ;

cdegrcode = 13 ; "MA" ;

cdegrcode = 16 ; "MS" ;

cdegrcode = 17 ; "NO DEGREE" ;

cdegrcode = 18 ; "PHD" ;

"No Degree" )

 

This works fine.

 

What I need to do however, is make this entry based on the date of the degree (field="cdatedegre"

 

This is the part that isn't working:

If ( cdatedegre > 9/1/2012 ; "Too Late" ; "Some other choice" )

 

What I expected to do was:

If ( cdatedegre > 9/1/2012 ; "Too Late" ;

Case ( cdegrcode = 1 ; "AA" ;

cdegrcode = 2 ; "AS" ;

cdegrcode = 3 ; "BA" ;

cdegrcode = 4 ; "OTHER BACHELORS" ;

cdegrcode = 5 ; "BS" ;

cdegrcode = 6 ; "CERTIFICATE" ;

cdegrcode = 7 ; "DOC CHIROPRACTIC" ;

cdegrcode = 8 ; "DOC OF OESTEOPATHIC SCIENCES" ;

cdegrcode = 9 ; "OTHER DOCTORATE" ;

cdegrcode = 10 ; "DOC DENTISTRY ";

cdegrcode = 11 ; "DOC VET" ;

cdegrcode = 12 ; "JD" ;

cdegrcode = 13 ; "MA" ;

cdegrcode = 16 ; "MS" ;

cdegrcode = 17 ; "NO DEGREE" ;

cdegrcode = 18 ; "PHD" ;

"No Degree" )

)

 

I have tried the If statement with the date in and out of "".

 

What do I have wrong with If ( cdatedegre > 9/1/2012

 

Thx,

Outcomes