Cryst4LN00B
IS-IT--Management
Hello there,
So I have a report that I need to get the last 7 days of Work counting from today, excluding Saturday and Sunday.
I'm new to Crystal and I searched on several websites and the only thing I get is with 2 intervals dates,
Using this query works
SELECT COUNT(*) FROM T_Orders WHERE DATE_Limit BETWEEN SYSDATE AND SYSDATE + 7 and trim(' ' from to_char(DATE_Limit ,'DAY')) not in ('SATURDAY','SUNDAY')
The problem is what command on Crystal Reports is the same as trim and for SYSDATE ?
Can anyone explain to me how do I convert this into a Select Expert-Record on Crystal Reports ?
Thanks for your help in advance,
So I have a report that I need to get the last 7 days of Work counting from today, excluding Saturday and Sunday.
I'm new to Crystal and I searched on several websites and the only thing I get is with 2 intervals dates,
Using this query works
SELECT COUNT(*) FROM T_Orders WHERE DATE_Limit BETWEEN SYSDATE AND SYSDATE + 7 and trim(' ' from to_char(DATE_Limit ,'DAY')) not in ('SATURDAY','SUNDAY')
The problem is what command on Crystal Reports is the same as trim and for SYSDATE ?
Can anyone explain to me how do I convert this into a Select Expert-Record on Crystal Reports ?
Thanks for your help in advance,