Using Crystal Reports XI
Hi, i've got a date field in my report which is data inputted manually by the user, however sometimes they get the year wrong, so i've changed my report to allow for current risks only, so my parameter i would like to be able to pick only the day and month and ignore the year. ie for november the user can choose the range 01/11 to 30/11. So hopefully that would pick up anything for november regardless of what year is in my date field.
I thought of a totext({@date}, "ddMM"), but obviously you couldn't do a range of dates on this in a parameter.
Any ideas please?
Hi, i've got a date field in my report which is data inputted manually by the user, however sometimes they get the year wrong, so i've changed my report to allow for current risks only, so my parameter i would like to be able to pick only the day and month and ignore the year. ie for november the user can choose the range 01/11 to 30/11. So hopefully that would pick up anything for november regardless of what year is in my date field.
I thought of a totext({@date}, "ddMM"), but obviously you couldn't do a range of dates on this in a parameter.
Any ideas please?