Link to home
Start Free TrialLog in
Avatar of jph826
jph826

asked on

Need a formula for "NextFullMonth" for a birthday report.

CRV10 - I have a birthday report that when the users runs it, the data returned needs to be a listing of employees with a birthday during the following or next full month. For example, If the user runs the birthday report any day in January, the result will be all birthdays in February.  
Here is the select criteria I use for previous month:  {PAEMPLOYEE.BIRTHDATE} in LastFullMonth
I can't find anything for NextFullMonth.  Any assistance would be appreciated.  Thanks!
Avatar of Mike McCracken
Mike McCracken

Something like
{PAEMPLOYEE.BIRTHDATE} in Date(Year(CurrentDate), Month(currentDate) + 1, 1) to DateDiff("M", 2, (Date(Year(CurrentDate), Month(CurrentDate), 1) - 1)

mlmcc
Avatar of jph826

ASKER

Thanks, I just tried it and it said a date is required here and hilighted the 2.  It also asked for another paren.
try it this way:

{PAEMPLOYEE.BIRTHDATE} in (DateAdd("m",1,minimum(MonthToDate)) to_ (DateAdd("m",2,minimum(MonthToDate))
Avatar of jph826

ASKER

Thank you!  I tried that but it brought back zero records.  I also had to add 2 more paren at the end.  I do not have any other criteria set, so it runs wide open.  Any other suggestions?
ASKER CERTIFIED SOLUTION
Avatar of bdreed35
bdreed35
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jph826

ASKER

Thanks, worked great.