I Know this is easyIwant 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
cfif year mod 2 eq 1ODDcfelseEVEN/cfif
-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 easyIwant a different background depending on the
year
chosen by the user
cfif Year MOD 2
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: donderdag 12 december 2002 14:32
To: CF-Talk
Subject: Wuick question: if odd/if even
I Know this is easyIwant a different background depending on the
year chosen by the user- basically if it ends
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
Thanks- I knew it was super easy
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 8:38 AM
To: CF-Talk
Subject: RE: Wuick question: if odd/if even
cfif year mod 2 eq 1ODDcfelseEVEN/cfif
-Original Message-
From: Janine Jakim
]]
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
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
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
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
9 matches
Mail list logo