Display Days Elapsed Between To Diffrent Date Fields??

[MarkR2207]

I have two fields a booking date & a release date. I wish to create a list of each day between these dates i.e. if booking date is 12/01/2003 and release date is 12/09/2003 I want to see 12/01/2003, 12/02/2003, 12/03/2003 etc. If this is possible, what do I need to do to get started? Thanks!

 

[vidru]

A little more info might help, especially by providing your expected output (Crystal version and database would be helpful too).

When you say 'a list of each day', does that mean:
12/01/2003, 12/02/2003, 12/03/2003, ... 12/09/2003

or

12/01/2003
12/02/2003
12/03/2003
...
12/09/2003

-dave

 

[bdreed35]

Mark:

Check out this article from CD's knowledge base (

http://support.crystaldecisions.com/library/kbase/articles/c2008492.asp).

It will allow you accomplish this fairly easily as long as there isn't a large gap between dates since it creates a string and there is a limitation on string lengths in Crystal (254).

There are also some techniques that other people have outlined here in Tek-Tips that require a table to be created in your database that would hold all possible dates. You can then do a left outer join from that table to the exisitng table that has you booking date in it. Do a keyword search to get more information.

~Brian