Search results for query: *

I am needing to find the # of days between dates (Min and Max) based on a date column and and event column. Here is an example: I have Sales Agents that I would like to group on. In the database their ID has a start date. They also have dates associated with that start date when any activity...

Yes, I am suspending dates within the range. If the event date starts on 08/01 and the end date is 08/05 (for this example counting everyday) that would give me 5 days. If 08/03 date in my table had a specific code next to that date then I would not count the 08/03 date. So instead of 5 days...

I am trying to calculate number of days between dates which i have a formula for (I believe this is the Ken Hamady formula): WhileReadingRecords; Local DateVar Start := DATE({EVENT_DATTIM}); // place your Starting Date here Local DateVar End := CurrentDate +1; // place your Ending Date here...

I have two tables I need to join and I need to join on a datetime field. One table has this field as CRDATTIM (which is create date time) and the other table has this broken down into three columns: Date column, time column, millisecond column. Do I concatenate those three columns in my query...

I am needing to find the # of days between dates (first and last) based on a group ID and one two other columns. Here is an example: I have Sales Agents that i would like to group on. In the database their ID has a start date. They also have dates associated with that start date when any...