Age in Flex Header

Kanani Reichlin $organization over 5 years ago

Hi All,

Me again with a conundrum regarding custom Flex Header Elements.

I've been trying to get a calculation of Age in years and months based on birthdate_1 attribute. I finally got my SQL to work in SSMS, but devastatingly when I put it into Tessitura the header is still giving me an error.

Anyone have this working in their database?

The forum is not letting me post my SQL code in this post. I'll try to follow up with it as a comment.

Thanks,

Kanani

Parents

Heath Wilder $organization over 5 years ago
Hi Kanani,

our age flex header element syntax is

select FLOOR(datediff (day, key_value, getdate()) / 365.25) from TX_CUST_KEYWORD where keyword_no = 1 and customer_no = @customer_no
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel
Kanani Reichlin $organization over 5 years ago in reply to Heath Wilder

Thanks, Heath. I think I'll keep this in my pocket as my plan B if I can't get it to display years and months. I'll have to ask our drama school how important that is to them. We're also showing birthdate in the header, so I'm assuming between the two they'll be able to make it work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Kanani Reichlin $organization over 5 years ago in reply to Heath Wilder

Thanks, Heath. I think I'll keep this in my pocket as my plan B if I can't get it to display years and months. I'll have to ask our drama school how important that is to them. We're also showing birthdate in the header, so I'm assuming between the two they'll be able to make it work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data