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

Date prompt problems

Started by bje, 10 Jan 2008 05:00:50 PM

Previous topic - Next topic

bje

I have 2 problems.

1)  I placed 2 Date Prompts onto the report and they look normal but at runtime they are date/time prompts and this is not what I placed there.  I dont see how to fix this in the properties.

2)  When I compare a field ( item ) to the date parameters it works just fine BUT if the field is in Query1 and I test it in Query2 against the same date parameters I get type mismatch errors.  What happens to items that come from a query ? Are they all converted to text, I was expecting them to be of the same type as they were in the package?
Confused.

Thanks!

bje

Well that was bizarre at least to me.

I ran it again and the date prompts became date prompts not timestamps.  I also cast(BeginDateprm) to 'timestamp' and it validates now.