Solved

Cognos 8.2--Pass date in correct format from date prompt?

Posted on 2009-05-07
4
2,617 Views
Last Modified: 2012-08-13
I have a date prompt on my prompt page that accepts a start date and end date for a period to search.  Normally I've used syntax like this:

between ?start_date? and ?end_date?

But this doesn't work for this date field.  The date requires a syntax like this:

[Referral_Date] in_range{2009-04-01 00:00:00.000:2009-04-30 23:59:59.999}

This will make it work, but I don't know how to make my date prompt pass the date like this?
0
Comment
Question by:IntercareSupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 12

Expert Comment

by:RWrigley
ID: 24340037
Assuming you need/want to use two date prompts, I'd use something like:
[Referral_Date] > ?StartDate? and [Referral_Date] < ?EndDate?

Altneratviely, you can use a "Date Range Prompt" instead of a "Date Prompt", and use
[Referral_Date] in range ?DateRange?
0
 
LVL 28

Accepted Solution

by:
burrcm earned 500 total points
ID: 24354131
Create a calculated column which displays the date as a date, not a datetime and use this for the prompt. Function - datetime-to-date.

Chris B
0
 

Author Closing Comment

by:IntercareSupport
ID: 31579071
Sorry, I forgot that I didn't close this out.  Thanks!
0

Featured Post

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question