If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Converting from datetime to int

Started by rr.bi1212, 26 Mar 2012 03:27:52 PM

Previous topic - Next topic

rr.bi1212

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

Lynn

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.

rr.bi1212

Lynn,

I have tried all those things and it did not work

Lynn

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?