Avatar of DollarBillIA
DollarBillIA
Flag for United States of America asked on

Crystal Date Difference

I am measuring how long it takes us to process and ship an order, I am using the following formula, which works great.

datediff("d",(datevalue({ebay_data.Paid on Date})),(datevalue({ebay_data.Shipped on Date})))

Except I need it to ignore Saturday and Sunday when figuring the date difference.

Help would be appreciated, thanks!

Bill
Crystal Reports

Avatar of undefined
Last Comment
vasto

8/22/2022 - Mon
vasto

DollarBillIA

ASKER
I had looked at that, but it lost me.  I am not super good at this stuff, and some of the items in his formula threw me.

Bill
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
DollarBillIA

ASKER
Thank you very much, I'll work with that.  Thanks for spoon feeding me, I need it!

Bill
Your help has saved me hundreds of hours of internet surfing.
fblack61
Mike McCracken

Since the formula was provided through the link in vasto's comment, he really should get a split of the points.  I'll reopen the question if you want.

mlmcc
vasto

Thanks mlmcc. This is very widely used formula and the credit should go to Ken anyway.  I don't think it is necessary to reopen the question.