Bithday alert or reminder

[#1]

Hello  Experts,

I have requirement where i hava a database where various person name and its date of birth details available.

Data has in two fields PersonName and DOB

PersonName,DOB

P1,01/01/1982

P2,04/11/1965

P3,02/03/1985

P4,06/07/2001

P5,08/04/1972

1. By person its current age on current date by how many years, months, day.

2. If any person has birthday in the current month shows alert message or by promting any indication in dashboard.

3. Higest age and minimum age.

Until this requrement if more i added on the thread

Thanks

[MK_QSL]

Please find enclosed file...

[#3]

Hi,

Thanks manish can you explain the load script i am newbie and cant understand proeprly.

Thanks

[MK_QSL]

It is just a mathematical calculation but difficult to explain.

You can do one thing...

Age(Today(),DOB) as AgeYears,

Try to find out how age function is working in QlikView Reference Manual

To understand the script, you need to understand below function... rest are just maths formulas.

Mode, Today(), AddMonths, Age..

Kindly mark correct/helpful answer if your requirement fulfilled.

[#5]

Hi,

Is there another way of doing same..

Thanks

[MK_QSL]

Does my reply not fulfilled your requirements?