RE: Wuick question: if odd/if even-1 more time!

2002-12-12 Thread Janine Jakim
OOPs My field isn't an integer- it's a string. It isn't just a year 2002/ but set as a school year 2002-2003 2003-2004 So the school year that ends in 2003 I want blue and the school year that ends in 2004 I want in purple... -Original Message- From: webguy [mailto:[EMAIL PROTECTED]]

RE: Wuick question: if odd/if even-1 more time!

2002-12-12 Thread Everett, Al
Subject: RE: Wuick question: if odd/if even-1 more time! OOPs My field isn't an integer- it's a string. It isn't just a year 2002/ but set as a school year 2002-2003 2003-2004 So the school year that ends in 2003 I want blue and the school year that ends in 2004 I want in purple

Re: Wuick question: if odd/if even-1 more time!

2002-12-12 Thread Clint Tredway
Try this: if (listlast(year) mod 2) year even else year odd - Original Message - From: Janine Jakim [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 12:09 PM Subject: RE: Wuick question: if odd/if even-1 more time! OOPs My field isn't an integer- it's

RE: Wuick question: if odd/if even-1 more time!

2002-12-12 Thread webguy
Maybe, #ListGetAt(year,2,-)# ?? Might need to double check its a number. trim(), Val() etc WG -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: 12 December 2002 18:10 To: CF-Talk Subject: RE: Wuick question: if odd/if even-1 more time! OOPs My field isn't