Filtet DateBirth due in 5 days

[matrixfree]

Hello to all,

We have this report that has besides many columns in a LIST report, a specific column that had the DateOfBirth of the employees.

We want to filter this LIST report in order to only display the employees that Date of Brith is 5 days from now.

Is that possible and how ?

Thanks !

[BigChris]

Cognos is good, but how is it going to forecast those employees that are going to be born in 5 days time?!?  ;)

Assuming you mean those people who will have their birthdays in the next 5 days...I'd think you 'd want something like:

_make_timestamp(year(current_date),month(DateOfBirth), day(DateOfBirth) = _add_days(current_date,5)

Obviously you'd need to tweak that for the 5 days from the 26th of December, but I'm sure you can sort that out.

[matrixfree]

Lol good one.... ;D

Thanks by the way I will test all that and see how it goes.

[Lynn]

Excellent answer Chris. I think the tweak you mentioned would just be extracting the year after adding 5 days to current date.

Code Select Expand


_make_timestamp(year(_add_days(current_date,5)),month(DateOfBirth), day(DateOfBirth) = _add_days(current_date,5)


[BigChris]

Yes, good shout Lynn...that ought to do it.