AnsweredAssumed Answered

Birthdays 21-28 days from CurrentDate

Question asked by Olex on Dec 16, 2011
Latest reply on Dec 18, 2011 by Olex

Title

Birthdays 21-28 days from CurrentDate

Post

Hi everyone,

 

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

calculation...

 

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

 

Thanks

Outcomes