Datetime parameter problem
Posted: Sat 02 Apr 2011 18:50
Hi,
I use SDAC TMSQuery to retrieve some date from SQL Server express 2005 SP2 server.
The following SQL Query is used
SELECT
[AccountNo]
,[CurrencyCode]
,[FirstName]
,[LastName]
,[Description]
,SUM([Credit]) AS Credit
,SUM([Debit]) AS Debit
,SUM([CreditUsingDefaultCurrency]) AS CreditUsingDefaultCurrency
,SUM([DebitUsingDefaultCurrency]) AS DebitUsingDefaultCurrency
,SUM([Debit] - [Credit]) AS Balance
,SUM([DebitUsingDefaultCurrency] - [CreditUsingDefaultCurrency]) AS BalanceUsingDefaultCurrency
, YEAR(NoteDate) AS Year
FROM [ReportAccountsTransactions]
WHERE ((:AllAccounts = 1) OR (AccountNo BETWEEN :FromAccount AND :ToAccount)) AND
((:AllDates = 1) OR (NoteDate BETWEEN :FromDate AND :ToDate))
GROUP BY [FirstName], [LastName], [AccountNo], [CurrencyCode], [Description], YEAR(NoteDate)
ORDER BY YEAR(NoteDate), AccountNo
The problem is that when I open the query after setting the parameters values, SDAC sends the date parameters values increased by one day.
Is it a normal behavior or I am missing something?
Thank You
I use SDAC TMSQuery to retrieve some date from SQL Server express 2005 SP2 server.
The following SQL Query is used
SELECT
[AccountNo]
,[CurrencyCode]
,[FirstName]
,[LastName]
,[Description]
,SUM([Credit]) AS Credit
,SUM([Debit]) AS Debit
,SUM([CreditUsingDefaultCurrency]) AS CreditUsingDefaultCurrency
,SUM([DebitUsingDefaultCurrency]) AS DebitUsingDefaultCurrency
,SUM([Debit] - [Credit]) AS Balance
,SUM([DebitUsingDefaultCurrency] - [CreditUsingDefaultCurrency]) AS BalanceUsingDefaultCurrency
, YEAR(NoteDate) AS Year
FROM [ReportAccountsTransactions]
WHERE ((:AllAccounts = 1) OR (AccountNo BETWEEN :FromAccount AND :ToAccount)) AND
((:AllDates = 1) OR (NoteDate BETWEEN :FromDate AND :ToDate))
GROUP BY [FirstName], [LastName], [AccountNo], [CurrencyCode], [Description], YEAR(NoteDate)
ORDER BY YEAR(NoteDate), AccountNo
The problem is that when I open the query after setting the parameters values, SDAC sends the date parameters values increased by one day.
Is it a normal behavior or I am missing something?
Thank You