Date question

[jtm311]

Hello All,

Is it possible to just replace the second date with something that will read today's date().
I have this as an operation. The below is the SQL statement.

sp_report TrialBalance show AccountFullName, AccountHasChildren, AccountListID, AccountName, AccountNumber, AccountSpecialType, AccountType, Credit, Debit, Label, NumColTitleRows, NumColumns, NumRows, ReportBasis, ReportSubtitle, ReportTitle, RowData, RowDataType, RowNumber, RowType Parameters DateFrom = {d'2012-01-01'}, DateTo = {d'2012-04-10'}

John

[Al Buchholz]

John

vcgQBEnd_Date="{d'"+dtoc(date(),"12-")+"'}"

sql="sp_report TrialBalance show AccountFullName, AccountHasChildren, AccountListID, AccountName, AccountNumber, AccountSpecialType, AccountType, Credit, Debit, Label, NumColTitleRows, NumColumns, NumRows, ReportBasis, ReportSubtitle, ReportTitle, RowData, RowDataType, RowNumber, RowType Parameters DateFrom = {d'2012-01-01'}, DateTo = "+vcgQBEnd_Date

Use that in an Alpha DAO import

[jtm311]

Thank you Al

I tried the above however getting an error.

Could not create ResultSet from DataSource definition.

[jtm311]

Al sorry I didn't see the line to make it a Alpha ADO. I have now created that connection. If I then use this connection in the operation I get the following error.
untitled.JPG
John

[Al Buchholz]

Al sorry I didn't see the line to make it a Alpha ADO. I have now created that connection. If I then use this connection in the operation I get the following error.
untitled.JPG
John

Alpha DAO and ADO are 2 different choices.

Build an import operation using Alpha DAO and apply the code to the SQL statement..

[jtm311]

Al I wrote ADO (sorry) but that error is when creating a Alpha DAO import operation.