Date Prompt

building reports webintelligence
1

Hi,

I wil be using date prompt which has date in format 12/27/2010
I need to show 6 months of ahead data and previous 3 months data
I need to compare in prompt Date > also another prompt Date <

sravyr (BOB member since 2010-05-04)

2

Ask your universe designer to create such a condition for you as it requires SQL code.

Andreas :de: (BOB member since 2002-06-20)

3

See Below Code

SELECT
  SCOTT.EMP.EMPNO,
  SCOTT.EMP.ENAME,
  SCOTT.EMP.JOB,
  SCOTT.EMP.MGR,
  SCOTT.EMP.HIREDATE,
  SCOTT.EMP.SAL,
  SCOTT.EMP.SAL,
  SCOTT.EMP.COMM,
  SCOTT.EMP.DEPTNO
FROM
  SCOTT.EMP
WHERE
  SCOTT.EMP.HIREDATE>
  add_months( to_date			 		            (to_char						(@prompt('Enter value(s) for Hiredate:','A',,Mono,Free,Persistent,,User:0)),'DD/Mm/YYYY'),-3)
   and
     SCOTT.EMP.HIREDATE>
  add_months( to_date
		(to_char						   (@prompt('Enter value(s) for Hiredate:','A',,Mono,Free,Persistent,,User:0)),'DD/Mm/YYYY'),6)

[Moderator Edit: Added code formatting - Andreas]

Rajubollas :india: (BOB member since 2009-09-04)