Link to home
Start Free TrialLog in
Avatar of 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)

Avatar of jph826


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


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?
Avatar of bdreed35
Flag of United States of America image

Link to home
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


Thanks, worked great.