Today's Date in Selection of Query

[former_member268711]

Hi,

I have a requirement to list orders (that have some exceptions) that are created on current date (Today's Date).  I will have a batch job so the query has to pick up the system date (today's date) automatically.

I have created the query through SQ01 and it is working with selection of document date (manual input). However, I need system to pick up today's date as either the creation date or document date of the transaction. 

Please let me know how I can achieve this requirement.

Thanks,

Abdul

[Former Member · Accepted solution]

Hi Abdul ,

You can create the variant for your query. In the variant, you can set the order creation date as current date by default.

Hope you are aware of creating the variant. If not, refer the following steps

1) In your query, press "save" button

2) you will get the following screen

Enter a variant name and dexcription

3) Find the creation date. against the line, maintain selection variable as "D" and Variable name as "Current date"

4) Save it. Variant will be created. You can use the variant name when you execute the batch job.

Regards

Vinu

[former_member268711 · Accepted solution]

Hi Vinu,

I didn't know about the selection variable.

Thank you so much for the step by step detail.

Regards,

Abdul