Search results for query: *

It is always 2 "Business Days", Monday through Friday, from Day Zero for the Target Date. So the two below that have Friday as Day Zero, Day One would be Monday and Day Two would be Tuesday, the Target Date. Day Zero Target Thursday, 4pm Thursday...

A "Business Day" would be Monday through Friday. Those days are the days that "count". If an order comes in on Friday and it is before 18:00 then Friday is day zero. If it comes in after 18:00 then Monday is day zero. If an order comes in any day over the weekend, Monday is day zero. The...

Orders can actually come in any day of the week, Monday through Sunday. Day zero starts on the first "Business day" and the formula I have counts Sunday as day zero if the order comes in on Saturday. It actually needs to have Monday be day zero.

Sorry, I forgot to include my @holiday formula. //Holiday Array Formula for the report Header: BeforeReadingRecords; DateVar Array Holidays := [ Date (2010,11,25), // you can put in as many lines for holidays as you want. Date (2010,12,24), Date (2010,12,31) ]; 0

Just wondering if anybody had any ideas on this? Thanks Ann

I need to determine the due date of an order. Orders come in between 18:00 of one day until 17:59 of the next day. Anything between 18:00 and 24:00 counts the next day as day 0. After 24:00 the current day is day zero. I need to show the due date (day 2). I have a formula from Ken Hamady...

I got it to work. Thanks

I have two fields, JobID and SubJobID, that need to be populated. I want to be able to write a barcode that will put in the JobID, then a tab, and then the SubJobID, all in one line. Our scanners automatically put in an enter after reading the code. I am using Code 39. Thanks

I am looking to display the update dates of several different excel files in one workbook. For example, I would like to display the date of books1.xls tools.xls jobs.xls all in excel file master.xls. A B book1 05/02/09 12:23:05 tools 05/01/09 11:35:45 jobs 05/15/09...

Thanks, I'll do that.

I am looking to display the update dates of several different excel files in one workbook. For example, I would like to display the date of books1.xls tools.xls jobs.xls all in excel file master.xls. A B book1 05/02/09 12:23:05 tools 05/01/09 11:35:45 jobs 05/15/09...

I have a problem similar to thread149-912093 except that my sequence of invoices are strings. Basically I have a list of InvoiceID's that are sequential, however, I need to identify the one's that have been deleted. For example... 10001 10002 10004 10005 10007 I need to be able to have the...

Thanks to both of you for your help. I added in the onlastrecord and that worked perfectly. I also excluded the On Holds...never thought to remove them. Thanks both. :) turtle_patch

I am working in Crystal 9.2 with an ODBC database. I have data that displays Job-id's, Location-id's, and Date of location change. Each job will have several location id's and I am trying to count the number of jobs in each location at the time of the prompted date. For example: job-id...

Thanks! That worked perfect. :)

I am working in Crystal 9.2 with an ODBC database. I have data that displays Job-id's, Location-id's, and Date of location change. Each job will have several location id's and I am trying to count the number of jobs in each location at the time of the prompted date. For example: job-id...