Home » Developer & Programmer » Reports & Discoverer » Custom Month-to-date Expression
Custom Month-to-date Expression [message #88384] Fri, 26 July 2002 13:05 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
Folks/Gurus,
I would like to develop a custom month-to-date SQL with the following logic:

1- If its regular day of the month, I need a month-to-date (1st of the month to yesterday's) data, eg if its july 26th, data should be from july 1-july 25th.
2- if its 1st of the month, I need last month's month-to-date data. if its july 1, data should be from june 1-june 30th.

If this possible in one statement?

Thanks for your time and help in advance,
Sam

Report message to a moderator

Re: Custom Month-to-date Expression [message #88385 is a reply to message #88384] Fri, 26 July 2002 13:59 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
http://www.orafaq.net/msgboard/newbies/messages/3391.htm

Report message to a moderator

Previous Topic: Oracle reports printing correctly from Oracle Applications
Next Topic: Discoverer Parameters drop-down list
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 19:45:06 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.