Method Community

I'm creating a report based on the customer table wherein I extract records that fall within a date range defined by two date picker objects on the screen and one other criteria.  If either or both of those fields are empty, I enter default  start and/or end dates as necessary.  I also save these two date values in a separate ...

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?

Thanks that worked great

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() - ...

Great. Thanks for finding and reporting Mark.

[quote user="CDS_Josh"]Is this possible?  I can get it to show as a date, but cannot convert to an integer or number[/quote] I'm not sure exactly what you're trying to do but I'll try to point you in the right direction.  If you look at the Edit screen for your calculated fields you should be able to change the ...

Another suggestion for you is to use the MethodAPI if you have access to developers.  You can handle a batch import of checks and deposits in this way. ~C