Is it possible to create valid-from and valid-to variables from Time out date(range) ?

[former_member211289]

Hi All,

I have a requirement to create a report which describes Pending Tickets.

My date field is Time out date(range) and in output ,I need to mention valid-from and valid-to.

Kindly give your valuable suggestions.

Thanks

Ram

[amitrathi239]

Have you tried with userresponse function to capture the  from & to date?

=userresponse("Prompt text")

[Former Member]

Could you please share the screen shot of your date range?

Can you try with Min() and Max() function to get From and To date?

Regards

Niraj

[former_member211289]

Hi All,

Requirement :

I need to create a report which describes closed tickets.

To create a report ,I have selection fields like user name,role,assignment type, review date (range) and reviewer name.

And my output has to be user name,role,assignment type, valid from ,valid to,date/time and reviewer name.

My query is ,Is it possible to create valid from,valid to and date/time variables using review date (range) ?

[amitrathi239]

Yes you can create but what will be the condition to create valid To & From date based on the Review date range

[former_member198519]

Edit the report query and put [Review Date] in the filter.

[Review Date]>= Prompt1 and [Review Date]<= Prompt2

OR

[Review Date] between Prompt1 and Prompt2

and then use Min([Review Date]) and Max([Review Date]) to select the desired data.

- Kuldeep

[former_member211289]

Hi Kuldeep,

Let me clarify one thing ,review date is basically a range .

so with out applying a filter, can't we create valid from,valid to and date/time variables directly using review date (range) ?

Please elaborate your explanation on this.

[former_member198519]

Of course you can. You can create two variable, [Min]=Min([Review Date]) and [Max]=Max([Review Date]). this will give you the lowest and highest value from the range.

Then play with the data as you want. Now you have Valid From and To date.

- Kuldeep

[former_member211289]

Kuldeep,

But previously you mentioned some different process i.e.,

[Review Date]>= Prompt1 and [Review Date]<= Prompt2

OR

[Review Date] between Prompt1 and Prompt2

and then use Min([Review Date]) and Max([Review Date])

1.Can you please explain why you mentioned filter instead of simply creating the variables ?

2.Also can we create a date/time  variable from review date(range) ?

[former_member198519]

That was when I was not aware that the date you are pulling in the report is already a range date. If it would have been otherwise, the best was to create a filter in the query.

I am not sure what values are coming in the review date. Can you give us a screenshot or sample data to play with?

- Kuldeep