Our company issues staff and their children travel passes.
PARTNER - they get a pass for the current calendar year to end on the last day of the year, eg: 31st Dec XXXX ( That's easy enough for me to figure)
Child passes - they end either as above at the end of the current year OR their 18th birthday, if that's sooner (I have their DOB stored as a date)
A partner or child will be categorised partner or Child in a text field on the record.
I need Case or If statement that will say that if they're a partner the expiry date is the end of the year, ( easy!) but if they are a child the expiry date is either the end of the year as above or their 18th Birthday if that's sooner.
If any bright spark can point me in the right direction I would be ever so grateful.
Thank you in advance from a very chilly Blighty!
min(Date(12;31;year(currentDate)); date(month(birthdate); day(birthdate); year(birthdate)+18))