Search results for query: *

Are you sure table 2 has no duplicates? Have you tried the Select Distinct feature? Since you're pulling from two tables, but the Account number isn't the same thing on each table, how are you linking the two tables, on what field?

Cool, I got it working Thanks for all your help

Also, I can create a formula that's just basically the end date - the start date and it works fine - it's the weekend piece that's throwing me, if that makes sense...so I basically know the fields are OK - it's something with this particular formula that isn't working for me...

both variables are a date and time - data looks like this: 01/01/2006 12:36 am

I'm hoping someone can help me here as well... I am trying to use the formula below, an altered formula from ken: [code] //Main formula WhileReadingRecords; Local DateVar Start = {V_BAR_SR.TAT_START_TIME}; // place your Starting Date here Local DateVar End = {V_BAR_ACTIVITY.ACTUAL_END_DT}...

Ok, here's another way I'm trying to do this...with a loop I'm create a DateVar 'Created' and setting it initially equal to the 'Created_Date' from the table. I'm also createing a NumberVar that's basically serving as a counter for the age. The loop basically checks the Created value and if...

Here's what I'm trying to do. I have a day that a task was created, we'll call it 'Created_Date'. What I want to do is basically return all the records where the created date is more than 7 days old. This part is easy enough with something like {%Date} > {Created_Date} + 7 where %Date is an...

I have the following series of IF statements in one formula, but when I try to save it's telling me that "The remaining text does not appear to be a part of the formula", and selects everything after the first If...Else statement. I would think this could be avoided with the EndIf command, but...