Birthdays 21-28 days from CurrentDate
I need to find Birthdays that are coming up between 21 and 28 days from CurrentDate.
I have "Full Date Of Birth" field that displays... you guessed it, full date of birth. :)
Then I created a new field "ThisYearBirthday" that was a calculation field (displayed as Date):
GetAsDate ( Day ( Full Date Of Birth) & "/" & Month ( Full Date Of Birth ) & "/" & Year ( Get ( CurrentDate ) ) )
Then I ran script that was searching in that field and included :
Get ( CurrentDate ) + 21 & "..." & Get ( CurrentDate ) + 28
Didn't have a problem with it, until I began getting into 2012... No birthdays would come up, only birthdays up to 31 December and that's it. :(...
Then I tried changing script and enquire in "Full Date Of Birth" field and included:
Let ( d = Get ( CurrentDate ) + 21 ; Substitute ( d ; Year ( d ) ; "*" ) )
It worked fine - I could see Birthdays that were 21 days from now, however I need to find a range between 21 and 28 days from CurrentDate.
And that's where I kinda stuck... Can't seems to understand how to add a range function to the above script line.
Hope someone can help me out with this one