[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Help needed



Hi all,
I'm trying to run a crytal report and when I enter the month and yeay in the 
prompt i'm getting an error message saying that the month should be between 1 
and 12...even though it is.
Then I get this window where it shows the following code..
 
({WORN_LET.ORIG_HIRE_DT}>=Date ({WORN_LET.:1 }-1, {WORN_LET.:2 }, 1) or 
{WORN_LET.REHIRE_DT}>=Date ({WORN_LET.:1 }-1, {WORN_LET.:2 }, 1)) and
(
(not ({WORN_LET.JOBCODE} in ["22085", "22087", "22108"]) and
(({WORN_LET.:1}*12+{WORN_LET.:2}-Year ({@doh})*12-Month ({@doh}))=4 and 
{WORN_LET.STD_HOURS} < 21 or
({WORN_LET.:1}*12+{WORN_LET.:2}-Year ({@doh})*12-Month ({@doh}))=3 and
{WORN_LET.STD_HOURS} >=21)) 
or
({WORN_LET.JOBCODE} in ["22085", "22087", "22108"] and
({WORN_LET.:1}*12+{WORN_LET.:2}-Year ({@doh})*12-Month ({@doh}))=6)
)
 
 
can any one pls throw some light ..
 
Thanks
Deepu

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users