Login / Register  search  syndication  about

          George Jensen's Blog

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

The DateRange Functions

Business Objects Crystal Reports comes with some really nice standard functions that make working with your data very easy.  I have been working on series of blog posts that introduces some of these functions to help SalesLogix report writers with their efforts.  Today I will focus on the start writing about function under the category of "Date Ranges"  The first set we will look at are the aging, more specifically Aged0to30Days, Aged31to60Days, and Aged61to90Days.

The function looks at the current date and depending on the function being used will return records that fall within the date range. 

The syntax for the formula is very basic:

{Table.DateField} in Aged0to30Day

So in SalesLogix, if I wanted to create a quick report that list all of Accounts created within the last 30 days I could write this Record Selection formula:

{ACCOUNT.CREATEDATE} in Aged0To30Days

To expand the functionality for my users, I could add a parameter with some choices like "0 - 30 Days" which will allow my users to select which of the three functions they want to use, my Record Selection Formula will then look like this.

if {?DateRange} = "0 - 30 Days" then {ACCOUNT.CREATEDATE} in Aged0To30Days
else
if {?DateRange} = "31 - 60 Days" then {ACCOUNT.CREATEDATE} in Aged31To60Days
else
if {?DateRange} = "61 - 90 Days" then {ACCOUNT.CREATEDATE} in Aged61To90Days

We could even go a little bit farther and add to our parameter some values like "Last 60 Days" and "Last 90 Days".  Then again edit our Record Selection formula and add:

else
if {?DateRange} = "Last 60 Days" then {ACCOUNT.CREATEDATE} in Aged0To30Days or {ACCOUNT.CREATEDATE} in Aged31To60Days
else
if {?DateRange} = "Last 90 Days" then {ACCOUNT.CREATEDATE} in Aged0To30Days or {ACCOUNT.CREATEDATE} in Aged31To60Days or {ACCOUNT.CREATEDATE} in Aged61To90Days

Nothing real fancy here.  I am sure there are other ways to get this same thing accomplished but I hope this gives some of the new users out there an idea of how to use these functions. 

Happy New Year!

Please have a plan and Stay Safe

What's This?
Bookmark and Share

About George Jensen

   George Jensen is a Senior Developer for Customer FX Corporation.


Related Content
   Looking at Stonefield Query for Sage SalesLogix (Part 5)
Sorry for the long absence, I went away on some training with the Minnesota National Guard.  This is
Posted on Sep 01, 2010 by George Jensen to George Jensen's Blog
 
   Picklist Column types - Dispaying ticket status in the SalesLogix LAN datagrid
I recently had to build a datagrid displaying ticket information, including the current Status value. Un
Posted on Aug 24, 2010 by Jason Buss to Jason Buss' Blog
 
   SalesLogix Cloud- Administration Options- Using Roles
In this webinar the user will learn to manage roles in the SalesLogix Web Client. These options are onl
Posted on Aug 20, 2010 by Dale Richter to Free SalesLogix Training
 
   SalesLogix 7.5.2 Speed Issues - How To Find the Slowdown
At times I have been asked how can I increase the performance of SalesLogix. For systems using SQL2005
Posted on Aug 13, 2010 by Mark Duthoy to SalesLogix Support
 
   SalesLogix Cloud- Administration Options- Creating a New Team
This Administrative webinar will show the user how to create a new Team for ownership of records. This is
Posted on Aug 13, 2010 by Dale Richter to Free SalesLogix Training
 
Comments

 

Twitter Trackbacks for The DateRange Functions - George Jensen's Blog [customerfx.com] on Topsy.com said:

Pingback from  Twitter Trackbacks for                 The DateRange Functions - George Jensen's Blog         [customerfx.com]        on Topsy.com

December 29, 2009 3:07 PM
 

Jason said:

I couldn't leave with our thanking you for your explanation. I search all over the web and this one was the most plain and down to earth of them all. Vital to a newbie like myself. Thanks again. It helped solved my problem.

April 27, 2010 3:26 PM
 

Horizon Duo Made, David Wojnarowicz Used Horizon Plymouth Colt said:

Pingback from  Horizon Duo Made, David Wojnarowicz Used Horizon Plymouth Colt

May 20, 2010 1:39 PM
 

J30 Free Shipping Qx4 Parts Infiniti Qx56, 1997 Infiniti J30 Photos Acura Integra said:

Pingback from  J30 Free Shipping Qx4 Parts Infiniti Qx56, 1997 Infiniti J30 Photos Acura Integra

May 20, 2010 6:51 PM
 

100 Replacement 1967 Ford F Pickup Parts, Logitech Harmony 1000 said:

Pingback from  100 Replacement 1967 Ford F Pickup Parts, Logitech Harmony 1000

May 20, 2010 8:05 PM
 

Lucerne Hid Riviera, Cadillac Coupon New Vehicles Buick Lucerne said:

Pingback from  Lucerne Hid Riviera, Cadillac Coupon New Vehicles Buick Lucerne

May 22, 2010 4:30 PM
 

1990 525i Body Kit Bmw 740il, 740i Detroit Auto Show Buick Regal Gs Lincoln Mkx said:

Pingback from  1990 525i Body Kit Bmw 740il, 740i Detroit Auto Show Buick Regal Gs Lincoln Mkx

May 22, 2010 4:47 PM
 

Auto 2000 Ford Windstar, Lamp Ford Windstar Fog said:

Pingback from  Auto 2000 Ford Windstar, Lamp Ford Windstar Fog

May 22, 2010 5:12 PM
 

525xi Sale Used Bmw 5 Series Monaco Blue Color Beige, 525xi Parts Oxygen Sensor Wiper Blade said:

Pingback from  525xi Sale Used Bmw 5 Series Monaco Blue Color Beige, 525xi Parts Oxygen Sensor Wiper Blade

May 22, 2010 7:10 PM
 

Removal Chevrolet Chevelle, 66 Chevelle Ss 396 Restored said:

Pingback from  Removal Chevrolet Chevelle, 66 Chevelle Ss 396 Restored

May 22, 2010 8:22 PM
 

1982 Oldsmobile Toronado Dodge Sale By Owner, Buy Oldsmobile Silhouette Replacement Headlight Assembly said:

Pingback from  1982 Oldsmobile Toronado Dodge Sale By Owner, Buy Oldsmobile Silhouette Replacement Headlight Assembly

May 22, 2010 8:50 PM
 

03 Mustang Gt Review, Ford Mustang Boss Gt said:

Pingback from  03 Mustang Gt Review, Ford Mustang Boss Gt

May 22, 2010 8:52 PM
 

Value 1994 Ford Econoline Diesel, Used Cars Super Duty F 350 said:

Pingback from  Value 1994 Ford Econoline Diesel, Used Cars Super Duty F 350

May 22, 2010 9:15 PM
 

Sale Used Rdx Acura Rsx, Discount Available Acura Rdx said:

Pingback from  Sale Used Rdx Acura Rsx, Discount Available Acura Rdx

May 22, 2010 10:09 PM
 

Honda Crf450x Stripe Kit, Ford E 250 F450 - 239.tgrconversions.com said:

Pingback from  Honda Crf450x Stripe Kit, Ford E 250 F450 - 239.tgrconversions.com

May 22, 2010 11:13 PM
 

Diferencias Nissan Altima Civic, Carbon Fiber Civic Euro Tail Lights - 233.renters.ws said:

Pingback from  Diferencias Nissan Altima Civic, Carbon Fiber Civic Euro Tail Lights - 233.renters.ws

May 23, 2010 12:48 AM
 

Durango Normal, Look Old Durango - 225.computeronlinebingo.com said:

Pingback from  Durango Normal, Look Old Durango - 225.computeronlinebingo.com

May 23, 2010 2:10 AM
 

5300 Infocus Screenplay Dlp Projector, Brand New Ford Focus - 338.mfbattle.com said:

Pingback from  5300 Infocus Screenplay Dlp Projector, Brand New Ford Focus - 338.mfbattle.com

May 23, 2010 2:21 AM
 

Cls550 Headlight, Bmw 750li Vs Mercedes S550 - 458.mfbattle.com said:

Pingback from  Cls550 Headlight, Bmw 750li Vs Mercedes S550 - 458.mfbattle.com

May 23, 2010 4:41 AM
 

1965 F100 Lightning 1956 Ford F 100, 1970 F100 Truck Parts 1965 Ford F 100 - 480.defutbolazo.com said:

Pingback from  1965 F100 Lightning 1956 Ford F 100, 1970 F100 Truck Parts 1965 Ford F 100 - 480.defutbolazo.com

May 23, 2010 5:34 AM
 

600sec Zone Pulsations Range, Pdf 600sec - 363.akemet.com said:

Pingback from  600sec Zone Pulsations Range, Pdf 600sec - 363.akemet.com

May 23, 2010 5:45 AM
 

Horizon Yachts Taiwan, Horizon Alternative - 85.jordanbrandallamerican.com said:

Pingback from  Horizon Yachts Taiwan, Horizon Alternative - 85.jordanbrandallamerican.com

May 23, 2010 6:41 AM
 

Part Brake Caliper Mercedes Benz 250se, 1967 Mercedes Benz 250se Cabriolet - 366.tgrconversions.com said:

Pingback from  Part Brake Caliper Mercedes Benz 250se, 1967 Mercedes Benz 250se Cabriolet - 366.tgrconversions.com

May 23, 2010 7:07 AM
 

Church Of Santa Maria De La Antigua In Seville, Noche Santa Fe - 265.tijuanareader.com said:

Pingback from  Church Of Santa Maria De La Antigua In Seville, Noche Santa Fe - 265.tijuanareader.com

May 23, 2010 7:12 AM
 

Caliber Mercedes Benz Lease Return Online Boutique, Caliber Uk Ltd - 439.binggreen.com said:

Pingback from  Caliber Mercedes Benz Lease Return Online Boutique, Caliber Uk Ltd - 439.binggreen.com

May 23, 2010 7:33 AM
 

Gmc K25 K2500 Suburban Rebuilt Engine Air Conditioner Compressor, Gmc K25 K2500 Pickup Replacement Tail Light Mirror Door - 167.akemet.com said:

Pingback from  Gmc K25 K2500 Suburban Rebuilt Engine Air Conditioner Compressor, Gmc K25 K2500 Pickup Replacement Tail Light Mirror Door - 167.akemet.com

May 23, 2010 8:44 AM
 

C35 C2500 Silverado Radiator Gmc Caballero, Caballero Season - 328.computeronlinebingo.com said:

Pingback from  C35 C2500 Silverado Radiator Gmc Caballero, Caballero Season - 328.computeronlinebingo.com

May 23, 2010 1:17 PM
 

Saturn Sc2 Horn Replacement, 1998 Saturn Sc2 Coupe 5 Speed Manual Transmission - 415.akemet.com said:

Pingback from  Saturn Sc2 Horn Replacement, 1998 Saturn Sc2 Coupe 5 Speed Manual Transmission - 415.akemet.com

May 24, 2010 9:34 AM
 

850i Tube Propylene Glycol, 850i Buy New Bmw - 116.computeronlinebingo.com said:

Pingback from  850i Tube Propylene Glycol, 850i Buy New Bmw - 116.computeronlinebingo.com

May 24, 2010 9:37 AM
 

F 250 Pickup Parts F550 Super Duty After Submitting Mitsubishi Fuso, F550 King Ranch For Sale - 26.an74.com said:

Pingback from  F 250 Pickup Parts F550 Super Duty After Submitting Mitsubishi Fuso, F550 King Ranch For Sale - 26.an74.com

May 24, 2010 9:43 AM
 

G1000 Series Episode Auto, Skylane Full Garmin G1000 - 156.eumreborn.com said:

Pingback from  G1000 Series Episode Auto, Skylane Full Garmin G1000 - 156.eumreborn.com

May 24, 2010 11:09 AM
 

Justy Exhaust Top Sellers, Justy For Sale Design - 259.rkwrh.com said:

Pingback from  Justy Exhaust Top Sellers, Justy For Sale Design - 259.rkwrh.com

May 24, 2010 11:24 AM
 

Australian Passport Picture, Promo Card Passport Renewal - 120.tijuanareader.com said:

Pingback from  Australian Passport Picture, Promo Card Passport Renewal - 120.tijuanareader.com

May 24, 2010 11:39 AM
 

Montero Aftermarket Parts Mitsubishi Outlander Lancer Evolution, Xg300 Promo Hyundai Parts Harmonic Balancer - 425.cmanager.org said:

Pingback from  Montero Aftermarket Parts Mitsubishi Outlander Lancer Evolution, Xg300 Promo Hyundai Parts Harmonic Balancer - 425.cmanager.org

May 24, 2010 1:23 PM
 

2010 Mitsubishi Lancer Evolution, Expo Cars Sale Mitsubishi Outlander - 63.renters.ws said:

Pingback from  2010 Mitsubishi Lancer Evolution, Expo Cars Sale Mitsubishi Outlander - 63.renters.ws

May 24, 2010 2:28 PM
 

S90 Weighted Action, S90 Dc - 165.mfbattle.com said:

Pingback from  S90 Weighted Action, S90 Dc - 165.mfbattle.com

May 24, 2010 3:59 PM
 

Mirada Ca Sheet Music, Adoption 1981 Dodge Mirada - 37.animejin.com said:

Pingback from  Mirada Ca Sheet Music, Adoption 1981 Dodge Mirada - 37.animejin.com

May 25, 2010 1:58 AM
 

Car Town Winnipeg Convention Centre Canadian, Town And Country Minivans - 7.jordanbrandallamerican.com said:

Pingback from  Car Town Winnipeg Convention Centre Canadian, Town And Country Minivans - 7.jordanbrandallamerican.com

May 25, 2010 2:56 AM
 

K15 K2500 Collection Headlight Door, Y12 K2500 Suburban Radiator 6.5 L Tdi - 226.cmanager.org said:

Pingback from  K15 K2500 Collection Headlight Door, Y12 K2500 Suburban Radiator 6.5 L Tdi - 226.cmanager.org

May 25, 2010 4:57 AM
 

Buy 2009 Honda Pilot Automotive, Mpeg Pilot - 271.defutbolazo.com said:

Pingback from  Buy 2009 Honda Pilot Automotive, Mpeg Pilot - 271.defutbolazo.com

May 25, 2010 12:31 PM
 

Ancient Greek Accentuation, Hyundai Accent Transmission Repair Maintenance - 250.tvshowzone.com said:

Pingback from  Ancient Greek Accentuation, Hyundai Accent Transmission Repair Maintenance - 250.tvshowzone.com

May 25, 2010 1:10 PM
 

Pictures Hyundai Xg350, Xg350 Selection Aftermarket Parts - 409.1fh.org said:

Pingback from  Pictures Hyundai Xg350, Xg350 Selection Aftermarket Parts - 409.1fh.org

May 25, 2010 2:09 PM
 

2006 Chevy Colorado Body Kits, E 250 Used Ford Shelby Gt500 Colorado Red - 333.animejin.com said:

Pingback from  2006 Chevy Colorado Body Kits, E 250 Used Ford Shelby Gt500 Colorado Red - 333.animejin.com

May 25, 2010 4:05 PM
 

Sl Part 2002 Saturn L200, 2001 Saturn L200 Lyrics - 353.luna-atra.net said:

Pingback from  Sl Part 2002 Saturn L200, 2001 Saturn L200 Lyrics - 353.luna-atra.net

May 25, 2010 10:09 PM

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