Jump to content

Using relative date ranges with Stored procedures


phillip.sdao

Recommended Posts

Im migrating reports from microsoft reports, to jasper reports, and the system im working with, works mostly with stored procedures. I want to use date ranges like "WEEK-1" but since its not supported in query or directly as a datatype, it seems as though the only way to do this is to make 2 normal date parameters as a prompt. Then feed those into 2 date range parameters, so that i can use the "WEEK-1" part. then feed those into 2 more parameters so that i can feed that into my query.

 

That seems like a really obnoxious way to have to do this. Is there a more convienet way?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...