Dynamic date in sql query

Not endorsed by or affiliated with SAP	Register \| Login
Not endorsed by or affiliated with SAP	Run impact analysis within your BOE platforms (Opens a new window)
Index \| About	Sponsors \| Contact Us \| Calendar \| FAQ \| Rules and Guidelines \| Privacy Policy \| Search

General Notice: Upcoming Events: BI SIG Event Auckland: May 31, CHIBOUG: Jun 21.

Dynamic date in sql query

Search this topic... | Search Business Query... | Search Box

Register or Login to Post    Forum Index -> Other Products -> Business Query

Author Message

fabdav
Forum Member

Joined: 17 Feb 2012

Posts: 2

Posted: Fri Feb 17, 2012 5:05 pm
Post subject: Dynamic date in sql query

I have this query:

Code:

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]

Back to top

foram_p
Forum Member

Joined: 31 Jul 2012

Posts: 3

Posted: Tue Jul 31, 2012 6:48 am
Post subject: Re: Dynamic date in sql query

what is 3gg

Back to top

Display posts from previous:

Register or Login to Post    Forum Index -> Other Products -> Business Query

Page 1 of 1 All times are GMT - 5 Hours

Jump to:

Index | About | FAQ | RAG | Privacy | Search | Register | Login
Get community updates via Twitter: Follow @BOB_Board

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0447 seconds using 17 queries. (SQL 0.0035 Parse 0.0357 Other 0.0055)
CCBot/2.0

Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com