Skip to Content
author's profile photo Former Member
Former Member

variables for dates

Hi Experts,

i am trying to design an query,in which i have two charecteristics named as Start Date & End Date.

The values for start date & end date are diffrent for some records and same for same records.

i have the requirement to use start date and end date in the selection screen for variable entry and i have tried a lot by using diffrent methods.

could any body please suggest the simplest way to solve this.if it would work with user exits, please please give me some sample coding.

Thanks

Debasish

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 07:18 AM

    Not sure try this -

    1. Create a Single value and User entry for Start Date.

    2. Create a Single value and User entry for End Date.

    3. In the query designer, restrict the Start date characteristic with this variable and while doing the restriction. Select the Selection as Value Rrange and then Greater than or equal to (for start date).

    4. Similarly, restrict the End date characteristic with the variable and while doing the restriction. Select the Selection as Value Rrange and then Less than or equal to (for end date).

    5. The idea is to ask the user for for single values of Start Date and End Date and then try running the query in that range.

    Hope the above steps helps.

    rgs,

    Parth.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.