Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

limit function range

Status
Not open for further replies.

jrcol12357

Programmer
May 9, 2007
39
US
This place uses a lot of stored functions. I want to make an a new report but have a different date range than what the original view pulls in from a existing stored function on dates. Instead of making a new stored function is there a way to use the existing function but limit it return for this case. In the view my new field is called for example newdate. I have tried to use both the stored function and "newdate" in the where clause: Where newdate > '01-may-07' or where sf_get_newdate > '01-may-07'. This is not working from an sql process. I know I could pull the original view into Crystal Reports and then set my where to the date range required. This was going to be just a simple query....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top