July 28, 201015 yr Im working on scripting a report and i want to perform a find on a specific field to include a date range. Im having some difficulties on how to perform the find to include a date range in the calculation. Basically what i am trying to do is pull the report to include everything for the next 3 days: Get ( CurrentDate ) ... Get ( CurrentDate ) + 3 Entering this calculation appears invalid. What would be the proper way to calculate this? Thanks
July 28, 201015 yr Are you scripting this, or entering a range in a [color:blue]date field Read about "[color:blue]Finding ranges of information" in the Online help and this Link Lee
July 28, 201015 yr You talking to me? If not, then get in a habit of using the Reply button in the post rather than the Quick Reply Button.
July 28, 201015 yr Author Thank you very much, it seems i always have an eye for overlooking the simplest things lol. thanks again
July 28, 201015 yr Yes, the calculation is invalid. You have not quoted the text string ... This works: Get ( CurrentDate ) & "..." & Get ( CurrentDate ) + 3 (Sorry Lee; generally I *am* in the habit of hitting reply but missed it this time) Edited July 28, 201015 yr by Guest
Create an account or sign in to comment