Upcoming Birthday 1

[BlurredVision]

Hello all.. I've been knocking my head against the wall..

I have a birthdate field.. I just need to know who has a birthday coming up within the next 45 days. Thought Dateadd would do the trick, but I can't seem to get it to work.. Thanks for any help given..

 

[lbass]

Try:

date(year(currentdate),month({table.birthdate}),day({table.birthdate}) in currentdate to currentdate + 44

-LB

 

[BlurredVision]

Thanks LB