Login / Register  search  syndication  about

          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
   Mobile 3.0.3 for Saleslogix v7.5.4, v8.0.0 & v8.1.0 is now available!
Saleslogix Mobile v3.0.3 is now available in the customer portals. This update addresses all issues int
Posted on Apr 14, 2014 by Scott Weber to SalesLogix Product Blog
 
   Editing Filters in Saleslogix Web Client 8.0
Is it possible to add or remove Saleslogix filters from the List view in Accounts?
Posted on Apr 08, 2014 by SalesLogix Support to SalesLogix Questions & Answers
 
   Creating a Unique Saleslogix table ID in a SQL Function
A couple of months ago Ryan Farley wrote an article about how to use a SQL stored procedure to create a S
Posted on Mar 25, 2014 by Kris Halsrud to Kris Halsrud's Blog
 
   Saleslogix Integration with Google - WOW!
Saleslogix will be releasing their Google Integration this month and from what I have seen, it is fantast
Posted on Mar 18, 2014 by Scott Weber to SalesLogix Product Blog
 
   Global Joins in the Saleslogix Web Client
Question: How can I make a Global Join stick in the Saleslogix Web Client? Currently, when I create a
Posted on Mar 07, 2014 by SalesLogix Support to SalesLogix Questions & Answers
 
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
 

250s Map, 250se Radiator Sl 600 Mercedes Benz Sl500 said:

Pingback from  250s Map, 250se Radiator Sl 600 Mercedes Benz Sl500

May 20, 2010 12:36 PM
 

500sel Music Mercedes, 500sel Lsd said:

Pingback from  500sel Music Mercedes, 500sel Lsd

May 20, 2010 1:39 PM
 

Ebay 65 Impala Parts, Trailblazer Oem Wholesale Prices Chevy Impala Parts said:

Pingback from  Ebay 65 Impala Parts, Trailblazer Oem Wholesale Prices Chevy Impala Parts

May 20, 2010 6:02 PM
 

Dodge Omni Cars Sale Grand Caravan, Omni Coolant Thermal Compound said:

Pingback from  Dodge Omni Cars Sale Grand Caravan, Omni Coolant Thermal Compound

May 20, 2010 6:51 PM
 

05 Super Duty Headlight Conversion, F 550 Dump Truck 1999 Ford F550 said:

Pingback from  05 Super Duty Headlight Conversion, F 550 Dump Truck 1999 Ford F550

May 20, 2010 8:05 PM
 

There Will Only One Highlander, New Highlander Movie Buy Christopher Lambert said:

Pingback from  There Will Only One Highlander, New Highlander Movie Buy Christopher Lambert

May 21, 2010 7:21 AM
 

E 550 Part Raptor, Sony Bdp S550 Pricegrabber said:

Pingback from  E 550 Part Raptor, Sony Bdp S550 Pricegrabber

May 21, 2010 11:27 PM
 

Shadow 1100 Vs Vtx 1300, Custom Cruiser Price Honda Shadow - 281.an74.com said:

Pingback from  Shadow 1100 Vs Vtx 1300, Custom Cruiser Price Honda Shadow - 281.an74.com

May 23, 2010 12:07 AM
 

Grandville Offers Discount Rates, Grandville Online - 160.myipgirl.com said:

Pingback from  Grandville Offers Discount Rates, Grandville Online - 160.myipgirl.com

May 23, 2010 12:28 AM
 

1800 Pet Meds Discount, Volvo 1800 Used Restoration Aftermarket - 369.unlockiphone30.net said:

Pingback from  1800 Pet Meds Discount, Volvo 1800 Used Restoration Aftermarket - 369.unlockiphone30.net

May 23, 2010 12:52 AM
 

1979 Ford Fairmont For Auction, 1993 Ford Fairmont Review - 248.tijuanareader.com said:

Pingback from  1979 Ford Fairmont For Auction, 1993 Ford Fairmont Review - 248.tijuanareader.com

May 23, 2010 1:23 AM
 

Cx 9 Replacement Fits, Fit Towel Cooling System - 393.rkwrh.com said:

Pingback from  Cx 9 Replacement Fits, Fit Towel Cooling System - 393.rkwrh.com

May 23, 2010 2:09 AM
 

200 I35 For Sale Infiniti Fx45, I35 Marketing Attorney - 118.jeepsunlimted.com said:

Pingback from  200 I35 For Sale Infiniti Fx45, I35 Marketing Attorney - 118.jeepsunlimted.com

May 23, 2010 4:30 AM
 

L300 Replacement Speakers Saturn Lw300, Buy Saturn L300 Price - 195.jeepsunlimted.com said:

Pingback from  L300 Replacement Speakers Saturn Lw300, Buy Saturn L300 Price - 195.jeepsunlimted.com

May 23, 2010 4:55 AM
 

325e Radiator Hd Ac Condenser, 325e Review Toro Ccr Powerlite Wet Snow - 382.ja3ra.com said:

Pingback from  325e Radiator Hd Ac Condenser, 325e Review Toro Ccr Powerlite Wet Snow - 382.ja3ra.com

May 23, 2010 5:27 AM
 

Hid High Quality Volkswagen Campmobile, Campmobile Used Turn - 234.1fh.org said:

Pingback from  Hid High Quality Volkswagen Campmobile, Campmobile Used Turn - 234.1fh.org

May 23, 2010 5:45 AM
 

E55 Vs E63, E55 Ptt - 419.luna-atra.net said:

Pingback from  E55 Vs E63, E55 Ptt - 419.luna-atra.net

May 23, 2010 6:19 AM
 

533i Price Tail Light, 533i Used Rear Spoiler - 90.luna-atra.net said:

Pingback from  533i Price Tail Light, 533i Used Rear Spoiler - 90.luna-atra.net

May 23, 2010 6:58 AM
 

B2600 Aftermarket B4000 Mazda B2300, B4000 Direct Fit Outlook Express Replacement - 327.cmanager.org said:

Pingback from  B2600 Aftermarket B4000 Mazda B2300, B4000 Direct Fit Outlook Express Replacement - 327.cmanager.org

May 24, 2010 9:43 AM
 

Uniden Bc350c Base Scanner Price, C55 Amg Sale C350 Sport 2008 Mercedes Benz C Class C280 - 459.jeepsunlimted.com said:

Pingback from  Uniden Bc350c Base Scanner Price, C55 Amg Sale C350 Sport 2008 Mercedes Benz C Class C280 - 459.jeepsunlimted.com

May 24, 2010 9:52 AM
 

1971 Oldsmobile Delta 88 L31 Buick Lesabre, Custom Convertible 1975 Oldsmobile Delta 88 - 211.binggreen.com said:

Pingback from  1971 Oldsmobile Delta 88 L31 Buick Lesabre, Custom Convertible 1975 Oldsmobile Delta 88 - 211.binggreen.com

May 24, 2010 11:08 AM
 

2001 Gmc Sierra Denali Vortec 6000, Q6000a Interest - 227.eumreborn.com said:

Pingback from  2001 Gmc Sierra Denali Vortec 6000, Q6000a Interest - 227.eumreborn.com

May 24, 2010 11:36 AM
 

Chevrolet V20 Suburban Part Automatic, 1999 Chevrolet Suburban 2500 Specs Cu Ft - 488.tgrconversions.com said:

Pingback from  Chevrolet V20 Suburban Part Automatic, 1999 Chevrolet Suburban 2500 Specs Cu Ft - 488.tgrconversions.com

May 24, 2010 11:39 AM
 

Chrysler Crossfire Dash Lights, Financial Sale Chrysler Crossfire - 210.rkwrh.com said:

Pingback from  Chrysler Crossfire Dash Lights, Financial Sale Chrysler Crossfire - 210.rkwrh.com

May 24, 2010 12:13 PM
 

1969 Sale 1964 Ford Econoline, E Class Econoline Step Bumper - 128.codebluehacks.org said:

Pingback from  1969 Sale 1964 Ford Econoline, E Class Econoline Step Bumper - 128.codebluehacks.org

May 24, 2010 1:23 PM
 

Celebrity 2008, Celebrity Halogen - 152.luna-atra.net said:

Pingback from  Celebrity 2008, Celebrity Halogen - 152.luna-atra.net

May 24, 2010 2:26 PM
 

2007 Chrysler Town And Country Touring For Sale, Yorktown Removal - 41.rkwrh.com said:

Pingback from  2007 Chrysler Town And Country Touring For Sale, Yorktown Removal - 41.rkwrh.com

May 24, 2010 2:32 PM
 

Mercury Grand Marquis Service Parts, Buy Mercury Comet 1970 Ford Maverick - 496.tijuanareader.com said:

Pingback from  Mercury Grand Marquis Service Parts, Buy Mercury Comet 1970 Ford Maverick - 496.tijuanareader.com

May 24, 2010 3:58 PM
 

Parts Es350 Fog Light Bulbs 2004 Lexus Es330, Order Es330 Auto Parts - 156.luna-atra.net said:

Pingback from  Parts Es350 Fog Light Bulbs 2004 Lexus Es330, Order Es330 Auto Parts - 156.luna-atra.net

May 24, 2010 3:59 PM
 

Discount 1991 Mercury Grand Marquis Mariner Hybrid, Mercury Mariner Mpg - 98.ja3ra.com said:

Pingback from  Discount 1991 Mercury Grand Marquis Mariner Hybrid, Mercury Mariner Mpg - 98.ja3ra.com

May 24, 2010 4:40 PM
 

Pb200 Oem V8, Plymouth Pb200 Price Know - 173.jeepsunlimted.com said:

Pingback from  Pb200 Oem V8, Plymouth Pb200 Price Know - 173.jeepsunlimted.com

May 24, 2010 4:51 PM
 

B2500 Aftermarket B4000 Mazda B2200, B2300 Pickup Mazda B4000 - 170.luna-atra.net said:

Pingback from  B2500 Aftermarket B4000 Mazda B2200, B2300 Pickup Mazda B4000 - 170.luna-atra.net

May 24, 2010 6:12 PM
 

Ebay Baseboard Aftermarket, Total Abdominal Hysterectomy Aftermarket - 483.myipgirl.com said:

Pingback from  Ebay Baseboard Aftermarket, Total Abdominal Hysterectomy Aftermarket - 483.myipgirl.com

May 24, 2010 6:19 PM
 

242 Body Kit Volvo 740, 242 Body Parts Volvo S80 - 121.unlockiphone30.net said:

Pingback from  242 Body Kit Volvo 740, 242 Body Parts Volvo S80 - 121.unlockiphone30.net

May 24, 2010 7:10 PM
 

W150 Replacement Complications, W150 Used Exhaust Manifold - 239.defutbolazo.com said:

Pingback from  W150 Replacement Complications, W150 Used Exhaust Manifold - 239.defutbolazo.com

May 24, 2010 7:18 PM
 

Dodge D300 Pickup Bulb Grand Caravan Wiring Harness, Dodge Caravan Pictures - 367.an74.com said:

Pingback from  Dodge D300 Pickup Bulb Grand Caravan Wiring Harness, Dodge Caravan Pictures - 367.an74.com

May 24, 2010 8:09 PM
 

Relay 1 Cooling System Experimental, Relay 2 Aftermarket Miss Wiring Harness - 321.defutbolazo.com said:

Pingback from  Relay 1 Cooling System Experimental, Relay 2 Aftermarket Miss Wiring Harness - 321.defutbolazo.com

May 24, 2010 11:32 PM
 

1995 C36 Review, Volvo C36 Auto Parts - 317.ja3ra.com said:

Pingback from  1995 C36 Review, Volvo C36 Auto Parts - 317.ja3ra.com

May 24, 2010 11:38 PM
 

Q45 Auction Used Cars Kelley Blue Book, Q45 Promotion Xm Navtraffic - 83.defutbolazo.com said:

Pingback from  Q45 Auction Used Cars Kelley Blue Book, Q45 Promotion Xm Navtraffic - 83.defutbolazo.com

May 25, 2010 1:20 AM
 

Ford Focus St For Sale, Replacement Headlight Assembly Ford Focus Zx2 - 134.cmanager.org said:

Pingback from  Ford Focus St For Sale, Replacement Headlight Assembly Ford Focus Zx2 - 134.cmanager.org

May 25, 2010 2:56 AM
 

500e Discount C36 C32 Amg C320, 500e Offer Now - 155.zapstreaming.com said:

Pingback from  500e Discount C36 C32 Amg C320, 500e Offer Now - 155.zapstreaming.com

May 25, 2010 5:03 AM
 

C320 Coupon E63 Clk63 Amg, E63 Cooling System Clk63 Amg - 123.1fh.org said:

Pingback from  C320 Coupon E63 Clk63 Amg, E63 Cooling System Clk63 Amg - 123.1fh.org

May 25, 2010 5:25 AM
 

2009 Matrix Floor Mats Toyota Tundra, 2010 Tundra Performance Upgrades - 449.renters.ws said:

Pingback from  2009 Matrix Floor Mats Toyota Tundra, 2010 Tundra Performance Upgrades - 449.renters.ws

May 25, 2010 5:38 AM
 

Buy Rx300 Is250 Lexus Sc300, Is250 Zone Sunroof Automatic - 206.animejin.com said:

Pingback from  Buy Rx300 Is250 Lexus Sc300, Is250 Zone Sunroof Automatic - 206.animejin.com

May 25, 2010 1:10 PM
 

Honda Odyssey Touring Used Cars Alloy Wheels, 1999 Honda Odyssey Review Sliding Doors - 147.jordanbrandallamerican.com said:

Pingback from  Honda Odyssey Touring Used Cars Alloy Wheels, 1999 Honda Odyssey Review Sliding Doors - 147.jordanbrandallamerican.com

May 25, 2010 1:30 PM
 

1998 Lexus Gs350 Engine, Es350 Theater Windshield Wipers - 18.luna-atra.net said:

Pingback from  1998 Lexus Gs350 Engine, Es350 Theater Windshield Wipers - 18.luna-atra.net

May 25, 2010 1:46 PM
 

Gx470 Radiator Oem Lexus Gs430, Gx470 Sale Used Lexus - 288.zapstreaming.com said:

Pingback from  Gx470 Radiator Oem Lexus Gs430, Gx470 Sale Used Lexus - 288.zapstreaming.com

May 25, 2010 3:06 PM
 

D300 Engine Age, D300 Turbo - 496.dlmreza.net said:

Pingback from  D300 Engine Age, D300 Turbo - 496.dlmreza.net

May 25, 2010 3:15 PM
 

Chevette Part Brazil Opel Manta, Carburador Chevrolet Chevette A?o - 222.luna-atra.net said:

Pingback from  Chevette Part Brazil Opel Manta, Carburador Chevrolet Chevette A?o - 222.luna-atra.net

May 25, 2010 3:46 PM
 

380slc Pushrod Bore And Stroke, Parts Catalytic Converter Mercedes Benz 380slc Power Steering Hose - 156.an74.com said:

Pingback from  380slc Pushrod Bore And Stroke, Parts Catalytic Converter Mercedes Benz 380slc Power Steering Hose - 156.an74.com

May 25, 2010 4:05 PM
 

Gs350 Pt Used Lexus Ls 600h, Gs350 Unlocked Windshield Wipers - 60.ja3ra.com said:

Pingback from  Gs350 Pt Used Lexus Ls 600h, Gs350 Unlocked Windshield Wipers - 60.ja3ra.com

May 25, 2010 4:48 PM
 

2 Replacement Auto Parts Saturn L300, Part 2002 Saturn L300 Car Safety - 145.unlockiphone30.net said:

Pingback from  2 Replacement Auto Parts Saturn L300, Part 2002 Saturn L300 Car Safety - 145.unlockiphone30.net

May 25, 2010 5:45 PM
 

Buy Corolla Models, Used Toyota Corolla 2000 Model - 177.ja3ra.com said:

Pingback from  Buy Corolla Models, Used Toyota Corolla 2000 Model - 177.ja3ra.com

May 25, 2010 6:29 PM
 

Ebay Bobcat Loader, Bobcat Photos - 52.tvshowzone.com said:

Pingback from  Ebay Bobcat Loader, Bobcat Photos - 52.tvshowzone.com

May 25, 2010 7:42 PM
 

Storm Hawks Episode 36, Scorpion Storm Selection - 75.renters.ws said:

Pingback from  Storm Hawks Episode 36, Scorpion Storm Selection - 75.renters.ws

May 25, 2010 7:44 PM
 

Casio Pathfinder Paw1500 1v Moon Phase, W150 Oem Battery Np Fg1 - 452.akemet.com said:

Pingback from  Casio Pathfinder Paw1500 1v Moon Phase, W150 Oem Battery Np Fg1 - 452.akemet.com

May 25, 2010 7:46 PM
 

Konica Minolta Mc2300dl Treiber, 1987 Mercedes 300d Wikipedia - 476.binggreen.com said:

Pingback from  Konica Minolta Mc2300dl Treiber, 1987 Mercedes 300d Wikipedia - 476.binggreen.com

May 25, 2010 8:40 PM
 

Ventura Lamp Leo Krol, Buy J2000 Sunbird Gto Pontiac Ventura - 431.renters.ws said:

Pingback from  Ventura Lamp Leo Krol, Buy J2000 Sunbird Gto Pontiac Ventura - 431.renters.ws

May 25, 2010 9:20 PM
 

He265 He360, 265 Discount Car Tires Bridgestone Dueler - 190.1fh.org said:

Pingback from  He265 He360, 265 Discount Car Tires Bridgestone Dueler - 190.1fh.org

May 25, 2010 9:47 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2014 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