Crystal Reports DateDiff Business Days

Crystal-reportsLogo1

How to Use the DateDiff Function to only show Business Days

The formula below will calculate the difference between the date in the table and the current date, while excluding Saturday and Sunday.


DateTimeVar date1 := {TABLE.DATE};
DateTimeVar date2:= currentdate;

DateDiff("d", date1, date2) - DateDiff("ww", date1, date2, crSaturday)-DateDiff("ww", date1, date2, crSunday)

0 comments

Crystal Reports DateDiff Function

Crystal-reportsLogo1

How to display the age of a record

One of the more valuable funtions in Crystal is the DateDiff function. It will allow you to see how old records are compared to a date you specify.

Below demonstrates how to use this function in several examples.

Crystal reports datediff years current date

The intervals are in years. The formula outputs the difference between the invoice date and today’s date.

[click to continue…]

0 comments

Auto-Reply on Every Outlook Email

outlook

Create a rule to make Outlook reply to every email

You need to create a rule that would send an automatic message to every email that is received in your inbox. You can not use the the Automatic Reply (Out of Office) feature because it will only reply once to an individual email. You need to set up a custom rule that will fire on every email received.

Below are the steps to create a custom rule that will have Outlook reply to every email that is sent to your inbox.

[click to continue…]

0 comments