Search results for query: *

Ro, It's been a while, have you had a chance to work on this... Thanks bsp

I'm guessing that this is a lost cause... Ro, thank you for all the help & time you've given me on this... bsp

Ro, this is for the first four that are wrong 5/13/2005 should be 5/11/2005 5/4/2005 should be 5/3/2005 4/22/2005 should be 4/21/2005 5/20/2005 should be 5/19/2005 If you look at a work calendar Monday thur Friday, it make it easier to figure out the start date Apri 2005 Mon Tue Wed...

Ro, I am so sorry for not giving the Crystal version, yes I am using 8.5 Using the last formula, here's what shows on the report, the first four give wrong Start Dates, last five give the correct start dates: LT Start Date Due Date 10 5/13/2005 5/25/2005 10 5/4/2005...

Rosemary, I thank you so much for all the help on this and I give you 5 stars for sure... But still having problems, I copied and pasted the formula so it was exactly how you wrote it, but I got a ) missing when I check the formula...when I click ok it put the cursor under the //end formula...

Rosemary, Your formula is so close, it works for some dates, but not for all, which makes no sense to me, maybe you can figure out why... Here is how I have the formula: //begining formula datetimevar pd := DateAdd("d",-{Part Master.MFGLT_01},{Order Master.CURDUE_10}); datetimevar sd :=...

Yes, in the formula above, d1 would represent the number of days it takes to build the part... and d2 would represent the date the part is due to ship... So I need to find the date they need to start building the part...start date, excluding weekends, When I use the datediff() formula above...

Any other ideas on this... I could really use the help Thanks

I guess I don't know what you mean... I'm trying to find the start date, so how can I add 10 days to it... Here's what I know: Duedate = Date Leadtime = Number Trying to find the start date, which equals the duedate - leadtime, but it has to exclude any Saturdays and Sundays. Thanks

The problem I'm having with the DateDiff formula is that d1 is a number, not a date field. I basically need a formula or multiple formulas to do the following: (5/13/2005 - 10) (exclude Saturday and Sunday) = 4/29/2005 Thanks

I need to find a startdate that excludes weekends. I have the duedate and the leadtime and I know how to subtract the leadtime from the duedate to give me the startdate, by using the formula below, but I need it to exclude the weedends... DateAdd ("D",-{leadtime},{duedate}) So, if the duedate...

That works great, thanks

How would I convert the numeric value of total time to a time value. Example: I have a total time value of 1.69, how do I convert that to show 1hr 41min.

rmiller11, this sounds like we are working on the same project, how can i contact you