BEx Date Selection Var with <= condition

[Former Member]

Hello Friends,

Have a requirement as follows: Have the user option to enter a date when the query runs and if the date is entered the query should pull all the records with <= user entered date.

I pulled the date field into Free Characterisitcs and Right Click-> restrict and changed the SELECTION (TOP LEFT) option to "Value Range" (so that I can use the option "less than or equal to" from "Top Right" box).. but unfortunately all I see the Variables are SAP content variables, .. How can I use my own "Z" variable on date field ??

Please let me know if I confused you/for any info..

Regards

Mavip

[Former Member · Accepted solution]

Hi,

To use the variable as you desired manner , the varible should represents "SINGLE VALUE" only .It should not represents 'Multiple' or 'range'...

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Anil,

Hi, its a perfect shoot.

I was created an Optional Variable and unfortunately all other "Z" variables were also Optional.. none of them were single.. so it was a bit strange to see all "0" variables when I was trying to set the condition.

Thanks for your time.. you are rewarded.. let me know if you didnot get the points.

Regards

Mavip

[former_member188975]

Hi Mavi,

You can create a variable based on Date as you would for any other char. On the left hand side of the query designer, find your char and under that you can create your variable.

Hope this helps...