SQL Server

[dmolnar]

I am trying to extract data from a sql server using a select and a where clause I am able to get everything i need except i cannot figure out how to use the where clause set to < the current date minus 1 can you please help me with this. The Task runs well with out the where clause but i really need it.

[forumsupport]

Hello,

You can use Variable Operation command to calculate date minus 1 then use this variable in SQL Query.

We have attached a sample task for your reference. To run this task,

. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy db1.mdb under c:\.

Hope that helps.

[dmolnar]

I copied in the Variable operation and the where clause and still get this error ---------------------------
Automation Anywhere Client Error
---------------------------
Incorrect syntax near '08'.



An error occured at line number 6.

Please open the task in the Task Editor to view the action at line number 6.
---------------------------
OK
---------------------------

[forumsupport]

Hello,

Is it possible for you to upload your task so that we can look into it and suggest the viable solution?

You can locate your task by selecting your task from Task List, right clicking that particular task and selecting 'Locate on disk' from context menu.
It would help us investigate further.

[dmolnar]

Yes Here it is

[forumsupport]

Hello,

We need to look into dbo.MissingWaivers table used in the task.

If you can email us your number at, http://www.tethyssolutions.com/support_form.htm then we can call you and resolve the issue.

[dmolnar]

OK sent it in