Method Community

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

That fixed it.  BTW  This is my company account so it's over 2 years old.

[quote user="AutumnW"]Any idea what could be going on or how to get them to show in QB?[/quote] You're not going to be able to batch import checks (or deposits) in this way.  There's background processing that goes on to create the transaction numbers and link up these records, the import/export tool is just not meant to ...