Crystal Date Comparison

Yahoo Archive
1
Thanks Vic. This should get me what I need.




________________________________
From: Vic Drecchio <Vic.Drecchio@...>
To: vantage@yahoogroups.com
Cc: kevmel822@...
Sent: Tuesday, August 11, 2009 10:08:14 PM
Subject: RE: [Vantage] Crystal Date Comparison

Dustin,

Look at the DateDiff() function:

{Date01} = Your First Date Value to Compare
{Date02} = Your Second Date Value to Compare

With DateDiff() you can find the total amount of days between two dates. Also with DateDiff() you can find the total amount of Saturdays and Sundays between two dates. Take the first and subtract out the second and you have business days. crSunday and crSaturday are Crystal Reports constants you can use in applicable formulas.Â

Your formula should look something like this:


// @BizDays


(DateDiff("d", {Date01}, {Date02}))

-

(
DateDiff("ww", {Date01}, {Date02}, crSunday) +
   DateDiff("ww", {Date01}, {Date02}, crSaturday)
)











Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of melissa hietala
Sent: Tuesday, August 11, 2009 5:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Date Comparison

Hi all,

In crystal, I need to compare two dates, and find how many WEEKDAYS difference there is between the two of them. So basically I need to find the total # of days difference between two dates, and subtract out any weekend days that occurred between those days. Any thoughts on how I can get this?

Thanks,

Dustin Biniek



  Â

[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links






[Non-text portions of this message have been removed]
2
Hi all,

In crystal, I need to compare two dates, and find how many WEEKDAYS difference there is between the two of them. So basically I need to find the total # of days difference between two dates, and subtract out any weekend days that occurred between those days. Any thoughts on how I can get this?

Thanks,

Dustin Biniek





[Non-text portions of this message have been removed]
3
Dustin,

Look at the DateDiff() function:

{Date01} = Your First Date Value to Compare
{Date02} = Your Second Date Value to Compare

With DateDiff() you can find the total amount of days between two dates. Also with DateDiff() you can find the total amount of Saturdays and Sundays between two dates. Take the first and subtract out the second and you have business days. crSunday and crSaturday are Crystal Reports constants you can use in applicable formulas.

Your formula should look something like this:


// @BizDays


(DateDiff("d", {Date01}, {Date02}))

-

(
DateDiff("ww", {Date01}, {Date02}, crSunday) +
DateDiff("ww", {Date01}, {Date02}, crSaturday)
)











Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of melissa hietala
Sent: Tuesday, August 11, 2009 5:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Date Comparison

Hi all,

In crystal, I need to compare two dates, and find how many WEEKDAYS difference there is between the two of them. So basically I need to find the total # of days difference between two dates, and subtract out any weekend days that occurred between those days. Any thoughts on how I can get this?

Thanks,

Dustin Biniek





[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links