Method Community

Thanks Dave.  That did the trick and I did have to play around with the date formatting. Much Appreciated!!!

Thanks David.  I understand that I can "Hard-Code" a date, but what i am trying to do is set up a variable that will be define in a Cell in excel (Which was part of the declaration section in my code above).  That way, if the users changes the date in that field, the query will automatically filter with the new ...

I am using your "GetInvoices" API example to create an excel report that will populate data.  The customer has requested that I create a date parameter for this information, but I have never been able to do this in the past. Here is my code where the issue is coming up: Dim STARTDATE As Date S TARTDATE = ...

I only use the generate report function to test my reports.  I find the preview screen to be extremely buggy and will not show any results at times, even though a generate report with a wide open filter range will show hundreds.  I really wish Method would spend more time working with this report designer and work out all the ...

Here is an example of what I am talking about (The values with the arrows pointing to them should be a 1 because both criteria are met)    

I am having nightmares with these functions in the Report Designer. Here is a simple formula that is not working and I cannot figure out why: Iif(([CallReport.ComplaintCode] = 'CA' and [CallReport.DateReceived] >= AddDays(Today(),-30)),  1, 0) Can someone help me out with this.  I have been designing reports for almost 15 ...

I had everything working fine and with ZERO changes to the above formulas, now it is no loner working correctly.  It just groups everything in "<= 30 Days".  I did not change a thing and it just stops working. Can we open this thread back up for suggestions?

I figured out a difference approach.  I created 3 Date Fields using the AddDay function for 30,60,90 days ago and then made my formula based off that. I really wanted to see the DATEDIFF fuction get incorporated because this is a great tool for aging reports. Thanks anyways.  I think I figure out what I need!! Here is my code for ...

Thanks for the reply, but I have already tried what you suggested and still get a date showing up in excel.  I know I can change the format in excel, but I have another calculated field in the report that runs off the "Days Aged" field. Here are the calculations for my fields: AgedDays: Now() - ...

I am having a heck of a time getting a Date Difference field to show as an Integer in report designer.  I also want to use this calculated field within another field to show Aging (30, 60, 90, >90).   Is this possible?  I can get it to show as a date, but cannot convert to an integer or number   Thanks in ...