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

Conditions: Variables on date key figures

Dear Sirs,

I am trying to create a condition on a key figure of type date (subtype: dats). I want the user to select a date interval for this condition, using variables.

The problems seems to be that the variable input screen thinks the user should enter an amount and not a date. If I enter a date in the variable then no data is beeing displayed.

So how can I get the variable to understand that the input is a date ?

Has anyone done what I try to do sucessfully.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 28, 2008 at 07:52 AM

    Assuming that you are using the variable created under a date parameter(e.g 0CALDAY) as an input in the selection screen. Don't create any variable for this and don;t use it in seletion screen

    Instead create a Formula variable of processing type as Replacement Path and replace it wil the 0CALDAY. Make it ready for input. So that will be available in the selection acreen. Also you can use this for creating condition.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello,

      I am still not able to get this to work. Can anyone confirm if they have solved the same issue, so I know it is feasible, and just me doing something wrong.

      I have a key figure of type date, DATS. I want to create a condition on this key figure, where the user type in a date range e.g 01.01.2000 - 01.01.2002, using variables.

      Possible?

      best regards,

      Jørgen

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.