Report Date Query

ghilton

Hello

I am having issues with a date query to run a report - What I wanted to do before the report is ran I want the user to imput a date then this date is taken to the nearest week start (Mon) and run the report for that week. I was looking at the function Business_Date_Back but i canot make this work?

Any Ideas on how I can do this or something similiar?

What we have is a credit check module and I want to find out is how many CC's where entered in a given week as a report for the CC manager

Thanks in Advance

technopak

Hi,

Assuming both your User Date Entered and your CC Date Entered are of type date, then the WEEK function should do the job for you - something like this should work:

FIND CC WHERE WEEK(CC_Date_Entered)=WEEK(User_Date_Entered)

Hope i've understood what you're trying to do.

Peter

ghilton

I think so ! What I am trying to do is work out how many CC's have been done in any given week!