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
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