Author Topic: Dynamic date selection  (Read 277 times)

Offline Kid_in_Cognos

  • Full Member
  • ***
  • Join Date: Feb 2015
  • Posts: 47
  • Forum Citizenship: +0/-0
Dynamic date selection
« on: 08 Dec 2017 03:34:19 am »
Hi ,

In my 'From date prompt', I want to restrict the user to choose only the last 1 year date only as we have the data for only last 1 year. Can you please suggest how to achieve it?

Kind Regards,
GS

Offline superdesi

  • Full Member
  • ***
  • Join Date: Oct 2017
  • Posts: 8
  • Forum Citizenship: +0/-0
Re: Dynamic date selection
« Reply #1 on: 08 Dec 2017 07:36:26 am »
How about default selection and then put a range.  In the properties section.

Offline Kid_in_Cognos

  • Full Member
  • ***
  • Join Date: Feb 2015
  • Posts: 47
  • Forum Citizenship: +0/-0
Re: Dynamic date selection
« Reply #2 on: 10 Dec 2017 10:52:05 pm »
Hi ,

Thank you much for your reply. I am sorry for not clearly mentioned my query.

I should have been more clearer on my request.

I will try to explain better.

we have audit data for last 1 year only. so every day it changing. If we run for today(11/Dec/2017) the last 1 year start date will be 11/Dec/2016.

If I run the report tomorrow, the last 1 year start date will be 12/Dec/2016 like that.

Then i have 2 prompts for From and To date.

So, is it possible to control the user to select the date dynamically as the 'From' date is keep changing daily?

Kind Regards,
Gowri Shankar

 


       
Twittear