BusinessObjects Board

Dynamic date in sql query

other Business Query
#1

I have this query:

SELECT
  
sum(DWPSALEH.EXTENDED_PRICE_LC *DWPCKGR.WEIGHTING_FACTOR )

FROM
  DWPSALEH,
  DWPCKGR,
  DWPDATE
WHERE
  ( DWPDATE.DATE_KEY=DWPSALEH.GL_DATE_KEY  )
  AND  ( DWPSALEH.CLERK_GROUP_KEY=DWPCKGR.CLERK_GROUP_KEY  )
  AND  
  DWPDATE.DATE_DATE  BETWEEN  {d '2012-02-13'}  AND  {d '2012-02-17'}

I would like to set as a range from the current date - 3gg to the current date. Is this possible?

[Moderator Edit: Added code formatting - Andreas]

fabdav (BOB member since 2012-02-17)

#2

what is 3gg

foram_p :india: (BOB member since 2012-07-31)