Formula for displaying monthly data 1

[tsjd]

I need a formula (using two parameters, month and year) which would display the records of a certain month without using any date formula as the fiscal year of the company is different compared to a calendar date.

Basically the fiscal period (month) within the pervasive sql data is of a number type while the year is of a string type. Can anyone help? I'm using Seagate Crystal Reports version 8.5

 

[Madawc]

You can use DatePart;

DatePart("yyyy", {your.date})

The same with "m" for month. Crystal 10 also has specific Month and Year commands, but I'm not sure if that applied for 8.5

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You would use a record selection formula like:

{table.period} = {?month} and
{table.year} = {?year}

...where {?month} is a number parameter and {?year} is a string parameter.

-LB

 

[tsjd]

thanks got it already