I presume you are looking for something like this. whats the datefield ? i am putting it as sampledate. i am adding trunc function to cutoff any time fraction from the dates.
select * from samples where sample_status ='B' and trunc(sampledate) between trunc(sysdate) and trunc(sysdate) + 7 hope this helps. regards Gopa On Jan 18, 2011 8:02 PM, "Hi_Its_Me" <manuel.floren...@gmail.com> wrote: Hi, I need to add a fied in crystral reports that i need to filter before. Sorry guys I dont know sql and have currently nobody around who could help me. My tryouts end all with error message. I need all the samples with sample status "B" for the next 7 days Table: Samples Rows SAMPLE_Status and SAMPLE_ID Is here somebody who coud help me? THX a lot -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
