Login / Register  search  syndication

          George Jensen's Blog

George Jensen on Reporting, Business Intelligence, Crystal Reports, Visual Analyzer, and more.

Using Functions to Look into the Future

If you find yourself in a position where you need to report into the future, Crystal provides a couple of functions that allow you control what data is displaying. 

First lets look at the AllDatesFromToday and AllDatesFromTomorrow functions.  These functions are found under the DateRanges group of functions in the Functions tree found in Crystal Formula Editor.

AllDatesFromToday, specifies a range of Date values that includes any date from the present day to any future Date value that may appear in a field. AllDatesFromToday includes the present day.

AllDatesFromTomorrow, specifies a range of Date values that fall after the present day. AllDatesFromTomorrow does not include the present day, but does include any future date.

The use of these functions are simple enough, the syntax looks something like this.

{ACTIVITY.STARTDATE} in AllDatesFromToday

The functions will provide all records that qualify no matter how far out. 

For this instances where you want to limit how far out you could use functions like one called "Next30Days". There are actually a couple additional functions along the same lines to include Next31To60Days, Next61To90Days, and Next91To365Days.  The syntax looks like this:

{ACTIVITY.STARTDATE} in Next30Days

Have fun reporting.

 

 

What's This?
Bookmark and Share

About George Jensen

   George Jensen is a Senior Developer for Customer FX Corporation.


Related Content
   Searching for Matching Records in the SalesLogix Web Client
In this short video the user will learn how to search for matching records while adding new records to th
Posted on Mar 10, 2010 by Dale Richter to Tech Talk
 
   Opening Several Records in the SalesLogix Web Client
This webinar will show the user how to open several records at one time. Often you would like to be able
Posted on Mar 10, 2010 by Dale Richter to SalesLogix Training
 
   The "What's New" Feature in SalesLogix Web Client
This webinar will focus on the functionality of the "What's New" Feature. This feature all
Posted on Mar 10, 2010 by Dale Richter to SalesLogix Training
 
   Converting a Lead in SalesLogix Web Client
This webinar will teach the user how to convert a Lead into an Account/Contact in your database. Leads a
Posted on Mar 10, 2010 by Dale Richter to SalesLogix Training
 
   Creating Lead Qualifications in SalesLogix Web Client
In this webinar the user will learn how create Lead Qualification questions necessary to qualify a lead
Posted on Mar 10, 2010 by Dale Richter to SalesLogix Training
 
Comments

 

Twitter Trackbacks for Using Functions to Look into the Future - George Jensen's Blog [customerfx.com] on Topsy.com said:

Pingback from  Twitter Trackbacks for                 Using Functions to Look into the Future - George Jensen's Blog         [customerfx.com]        on Topsy.com

January 14, 2010 2:16 AM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2010 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register