Birthday List Parameters Cover Year End

[ladporter]

Hi again

Have data basically as follows:

id age ddob day month month_mmm
124729 18 28/12/1991 28 12 December
27174 24 28/12/1985 28 12 December
42755 20 29/12/1989 29 12 December
23671 23 29/12/1986 29 12 December
172089 25 30/12/1984 30 12 December
34833 27 31/12/1982 31 12 December
22937 21 1/01/1989 1 1 January
34129 19 1/01/1991 1 1 January
36656 19 4/01/1991 4 1 January
29852 22 4/01/1988 4 1 January

The report required is a list of members whose birthday fall between two parameter dates. The problem is when dates cover year end. For example if parameter start_date 29/12/2010 to end_date 01/01/2010 and record selection month > month(start_date) and month < month(end_date). I see no records returned as it translates to month >12 and month <1.

Tried creating formula for what their birthday would be in each year i.e Date(day,month,year(start_date)and Date(day,month,year(end_date) for record selection against start and end dates but no luck.

Can anyone suggest a solution.

Thanks ladporter

 

[lbass]

Try something like this:

datevar x := {table.dob};
(
date(year({?Enddate}),month(x),day(x)) in
{?Startdate} to {?Enddate} or
date(year({?Startdate}),month(x),day(x)) in
{?Startdate} to {?Enddate}
)

-LB

 

[ladporter]

Thanks lbass

Once again your answer I guess I 100%.

After I posted I did try calculating member ages at start and end of the range and filtered where age_start < age_finish i.e. their age went up in that period. It seemed to work but your approach seems more straightforward.

Thanks once again for your assistance.

ladporter .

PS In CR 2008 is it possible to change toolbar icon size. In CR XI there was toolbar option for Visual Theme Large Buttons.

 

[lbass]

I don't know. Where did you find that option in CRXI? I don't see it.

-LB

 

[ladporter]

Using CR 11.0.0.1282. Right Click on toolbar. Select last option Toolbars... At the bottom of the dialog that comes up it has a section Visual Theme and there is a tick box available for Large Buttons. This makes the icons about 9mm square.

Am looking for same option in CR2008 as I use a 24" with resolution 1920x1080 and the icons are about 5mm square and not easy to see or click. Must be getting old!

Regards

ladporter

 

[lbass]

This is a nice feature--but I couldn't find it in CR 2008 either. I also find the toolbars in CR 2008 to lack contrast, making it more difficult to distinguish activated icons from inactive. I am especially bothered by the lack of contrast in the Save icon--it is difficult to tell the difference between saved and unsaved.

-LB