how to replicate this filter in cognos
birthDt + 56 <= Date Range
where birthDt is datetime and also tell me how should I put Daterange in that particular filter
You can't specify <= with a date range. It would need to be a specific date. A between operator would let you see if a date falls within a specified start and end.
Look at the _add_years function to add 56 to the birth date. Look at the _make_timestamp function to specify the value you want to compare.
Lynn,
I have tried all those things and it did not work
You'll need to provide some specifics. What didn't work? What was the expression syntax? Did you get an error or an incorrect result? If you got an error, what did it say? If you got incorrect results, how was it different from what you expected?