Date formula using color

[stephm923]

I'm trying to do a formula in Crystal 10.


I want to highlight lines that have a ymdend >= {@EFFDATE} and <= "last day of month of {@EFFDATE}"

For instance, I want the lines to be highlighted when the ymdend is between 08/01/2006 and 08/31/2006.

This is what I have so far....
IF {vADV_RX_LICENSE.RX_LICENSE_YMDEND} = {@EFFDATE} and
{vADV_RX_LICENSE.RX_LICENSE_YMDEND} <= ??? THEN CRSILVER ELSE CRWHITE

**ymdend is a datetime field

 

[synapsevampire]

We don't know what's in {@EFFDATE}, nor it's data type (date or datetime?).

This should work though:

IF {vADV_RX_LICENSE.RX_LICENSE_YMDEND} = {@EFFDATE}
and
{vADV_RX_LICENSE.RX_LICENSE_YMDEND} <= dateserial(year({@EFFDATE}),month({@EFFDATE})+1,1)-1 THEN
CRSILVER
ELSE
CRWHITE

-k

 

[stephm923]

Worked perfectly!
Thanks!