• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2670
  • Last Modified:

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

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
IntercareSupport
Asked:
IntercareSupport
1 Solution
 
RWrigleyCommented:
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
 
burrcmCommented:
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
 
IntercareSupportAuthor Commented:
Sorry, I forgot that I didn't close this out.  Thanks!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now