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

Question

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

yaseennawaz · Answer

Thanks Asim

asim cholas · Answer

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}')