topic Re: Dynamic current date variant with static date in Application Development and Automation Discussions

Dynamic current date variant with static date

Former Member — Fri, 24 Feb 2012 20:33:12 GMT

I have a report that I want to execute with a variant that defaults dynamically to today's current date, but I also want to select based on if that date field is initial too. In one execution. So select record if date is either today's date (dynamically calculated) or date is initial.

Anyone know how I can do that?

Thanks so much

Cathy

Re: Dynamic current date variant with static date

Former Member — Fri, 24 Feb 2012 21:26:59 GMT

Try something like this:

Select date

From ztable

Into table gt_table

Where date eq gv_dynamic_date

Or date eq space.

Re: Dynamic current date variant with static date

vijaymanikandan — Fri, 24 Feb 2012 21:31:44 GMT

I hope you must have done some research on this. Post your code with the issue here.

You can default your date in initialisation event. Else have one hidden selection screen variable which date you can default to current date and another variable that you display to user which can be blank as well..

Re: Dynamic current date variant with static date

Former Member — Fri, 24 Feb 2012 21:54:57 GMT

I'm sorry, I should be a bit more clear. I have an SQ01 query that gets executed throughtout the day with a variant.

The variant is configured to default PGI date to todays current date. But I also want it to select all PGI dates that are initial too.

I can change the generated SQ01 code, but I was hoping there was a way to do that just through the variant set up.

Re: Dynamic current date variant with static date

vijaymanikandan — Fri, 24 Feb 2012 22:11:34 GMT

Did you try to force value in the variant in the multiple value with a value equal to space? So it will be like default date as today's date and fixed values as space.

Force value in the sense we use fixed values in the selection screen.

If this is not working then do coding in infoset

Vijay V

Re: Dynamic current date variant with static date

Former Member — Fri, 24 Feb 2012 22:29:36 GMT

Yes, if I force the initial date in the variant, then the current date becomes static. It no longer calculated current date, the next day when it's run. Can't code the infoset, I don't think, because there's about 5 different variants and they all use different dates.