Win10 LO22.214.171.124 HSQL2.51
Reworking my one year old first attempt of an alert functionality. Basically I have Documents and Contracts having an expiry date, Birthdays which are repeats, People who havent been in contact since, Accounts that need to be renewed etc.
When I did this first I shy-ed away from a union query as no can sort and read only. Now I actually can sort a union indirectly by creating a view and then a query on that view for the form.
The form has fields like AlertType, DueDate, RemindMeDaysBefore and DaysLeft amongst other things.
My only problem I can not figure out how to get the DueDate for a persons next birthday as the actual DOB is static, but birthdays happen every year.
I have troubles getting any result with datediff which might be the wrong function to do this.
So basically I need the next birthday as date regardless if the bd is in the current or the next year.
Hope this makes sense
Thanks for any ideas
Thank you Ratslinger, I edited this post as I cant add images to a comment…
Thanks @ Ratslinger, works if the nbd field is populated first with the DateOfBirth, yet I have
difficulties getting the id and an alias for C1 into the output
I did something similar about a year ago using TO_CHAR( DATEADD( ‘year’, 1, “Date” ), ‘DD/MM/YY’ )
but how would I convert this string back into a real date