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 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]] > Sent: Thursday, December 12, 2002 8:44 AM > To: CF-Talk > Subject: RE: Wuick question: if odd/if even > > > yeap, here u go > > if (year mod 2) > year even > else > year odd > > you can use IIF like this too, but the above is easier to read... > > WG > > > > -----Original Message----- > > From: Janine Jakim [mailto:[EMAIL PROTECTED]] > > Sent: 12 December 2002 13:32 > > To: CF-Talk > > Subject: Wuick question: if odd/if even > > > > > > I Know this is easy....Iwant a different background depending on the year > > chosen by the user- basically if it ends as an odd number make background > > blue if year ends with even number make background green. Is > > there a better > > way than saying <cif (Right(#Year#, 1) EQ 1) or (Right(#Year#, 1) EQ 3) or > > (Right(#Year#, 1) EQ 5) or (Right(#Year#, 7) EQ 1)etc..... > > Thanks, > > j > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
