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

Default value for time characterstics in query selection

I need to provide a default value for time characterstic selection in Query selection, the date range should default to: from (six months ago) to (current month).

Can anyone please help?

Thanks,

-A

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2005 at 03:15 PM

    Use a variable to ask user year/month current; then use in restriction range from variable offset -6 to variable.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      1)Put 0calmonth in the free characteristics

      2)Right-click and select "restrict"

      3) in this screen, top left dropdown box, change this to "value range"

      4) go to the variables tab

      5) select a SINGLE variable (not a range one!) - in your case "current month" would be good (if it's not there go look in BCT and install it)

      6)you can now see 2 values on the right screen (from, to) but they are both the same. To fix this...

      7) right click on this values and select "offset"

      8) the first value you see is "from", change the 0 to -6. Click ok

      9) the second value you see is "to", leave the 0 and click ok

      10) done, now you can see that the values say -6 to 0

      should do the trick 😊

  • Posted on Oct 17, 2005 at 03:17 PM

    Hi Abs,

    You should be able to do this by creating a user exit variable. There are several examples in the forum, but post back if you need mroe help.

    Or you can also try with the variable for current month and use an Offset of -6.

    Hope this helps...

    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.