Custom Reports cannot access 2011 dates
Posted: Sun Dec 19, 2010 10:06 am
I have a custom birthday report, so that I can print address labels, but the report won't allow me to show birthdays in 2011. Can we get this updated?
tmellor wrote:I have a custom birthday report, so that I can print address labels, but the report won't allow me to show birthdays in 2011. Can we get this updated?
If you really want the Birth Date, then choose that field (rather than "Birthday"). The "Birth Date" does include a year. But for a custom birthday report, you probably do simply want the "Birthday", as jdlessley accurately described.jdlessley wrote:A birthday is based on a day and a month only and does not include the year. To create a list of all birthdays for 2011 the criteria would include the attribute Birthday, the compare operation "is or is after", and the value "01 Jan". Note there is no year.
This doesn't sound right. In the calendar control (Select Date control) you should not be able select a year beyond the current year. I do not know how you are able to select Jan 1, 2011. You may want to check your system date to see if it is correct.tmellor wrote:When I use the calendar control and choose Jan 1, 2011...
If I use Birthday then I can't change the year to the future in the control - which makes sense since the year doesn't apply for the comparison.tmellor wrote:Thanks for the replies!
Alan_Brown: I do want the Birthday rather than the Birth Date, but it's good to know I can use both. (even though Age seems to be easier for most situations).
jdlessley: When I use the calendar control and choose Jan 1, 2011, no results are returned. I presume that if I change it to Jan 1, 2010 it will work and give me the correct results. So for some reason picking Jan 1, 2011 and picking Jan 1, 2010 seem to resolve to something different even though they both just show Jan 1 after dropping the year. I'll use the workaround, but it may be worth double checking there isn't a bug in the calendar control. Let me know if you can't duplicate this behavior.