Hi, I am using MS VS.Net 2003 and C#. I am trying to setup a selection formula for date using crsytal report. I know that we have to format the date criteria, but I have no clue how to do it. I would really appreciate if anybody can give me some code example on how to setup the selection formula for date. I am trying to lookup records that match the date criteria..lets say for all records posted in the last 7 days etc. Anxiously waiting for a reply. Salmaan

Well I don't have any C# experience or Crystal Reports, however if your data is not in normal order, then just make a for loop and do something like if (datadate >= currentdate - 7) or if it is in order by date then just do a for loop and once you hit one that isn't the correct date, break from the loop.

Hi, Thank you for your response, but here when I am using Crystal Report for VS.NET I have to use a specific crystal syntax which by the way is different for each programming language i.e., VB, C# etc. Therefore, I need help in figuring out how to code the selection criteria for the date field. I can pretty much do it for any other type of fields. Thanks for your esponse though. Salmaan