Age Bucket

[rahulsingh12]

Hi,

I have created a link table using two table A and B.

Both the tables have a date field in them.

I want to create age bucket using that link table such that when ever any value of the common date from link table is selected it should calculate the age for that date from table A and B till the common date from Link Table.

A----->Link Table<-----B

Regards,

[el_aprendiz111]

Hi

function Interval(Date1,Date2,'d')

o

Would you be able to share a sample with the expected output?

[rahulsingh12]

Hi i have attached a file.

From the link table date field and the date field from any of the table A and B I want to create a age bucket.

Link Table         

29/04/2015

A

24/05/2017

Age_Bucket

<30 days

This bucket will change when the selection of common date changes.

Regards