Need to populate 60 dates in second prompt based on the date in first prompt

yaseennawaz

Hi,

I have two prompts in the prompts section.One is a Forecast Effective Date and the other Transaction date.If I give a date in the first prompt ( Forecast Effective Date) then I should get list of next 60 dates(all the dates)  including the forecast effective date in the second prompt(Transaction date).Please let me know how this can be achieved.

Regards,

Yaseen

asim cholas

Create a prompt for your forecast date , make it auto apply ( uncheck the apply button from properties of prompt) and keep a presentation variable.

Create a second prompt and make the results as SQL Results and keep the below formula

SELECT YourTrxDateColumn FROM YOurSubjectArea  where YourTrxDateColumn between Date '@{Fdate}{2017-11-11}' and timestampadd(SQL_TSI_DAY,60,Date '@{Fdate}{2017-11-11}')

yaseennawaz

Thanks Asim