• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1861
  • Last Modified:

How to make an array of dates in Crystal

I need to check for holidays in my report.  I put this formula in the report header.

I have tried to make an array of dates in Crystal as follows:

BeforeReadingRecords;
Local DateVar Array Holidays:= MakeArray(Date(2011,01,01),Date(2011,12,25))

I get an error message that says "Result of formula cannot be an array"

How do I format the formula to create the array?
0
DSIGRIS
Asked:
DSIGRIS
  • 4
  • 3
1 Solution
 
mlmccCommented:
Try it this way

BeforeReadingRecords;
Local DateVar Array Holidays:= [Date(2011,01,01),Date(2011,12,25)];
""

Crystal returns the value evaluated in the last line as the result of the formula.

mlmcc
0
 
mlmccCommented:
Not sure what you are doing but here is a formula that does the Number of WorkdDays between 2 dates and account for holidays

http://www.kenhamady.com/form01.shtml

mlmcc
0
 
DSIGRISAuthor Commented:
I was trying to implement your solution for calculating the difference between two dates.

//Holiday Listing formula to go into the report header of the report.
BeforeReadingRecords;
DateVar Array Holidays := [Date (2003,12,25), Date (2003,12,31)];

But this gives me an error.

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
mlmccCommented:
You need a final line that is a scalar value like ""

//Holiday Listing formula to go into the report header of the report.
BeforeReadingRecords;
DateVar Array Holidays := [Date (2003,12,25), Date (2003,12,31)];
" "

mlmcc
0
 
DSIGRISAuthor Commented:
Why is that?
0
 
mlmccCommented:
Crystal returns the value from the last statement it executes or evaluates as the value of the formula.  In your case the declaration of the array so it tries to return the array as the value which is not allowed.

If you had used
//Holiday Listing formula to go into the report header of the report.
BeforeReadingRecords;
DateVar Array Holidays := [Date (2003,12,25), Date (2003,12,31)];
numberVar HolidayCount := 2;

That would be fine because it would return 2 as the value.

Formulas on the report need to display something.

mlmcc
0
 
DSIGRISAuthor Commented:
Great Job thanks.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now