SQL Statement for Date

ffchen · February 28, 2011, 3:17am

I have try the following SQL, but found the error message ( Operand Type are not compatible with the operator )

Select SUM(LineAmount)
from salesLine
where salesLine.salesLine.ShippingDateRequested == “2/24/2011”;

kollinaresh.k · February 28, 2011, 4:07am

Hi Michael,

Change the query to

select sum(LineAmount) from SalesLine
where SalesLine.ShippingDateRequested == 24\02\2011;

Naresh Kolli

ffchen · February 28, 2011, 4:15am

Hi Naresh,

Thanks for your help. It work!!!

I would like to ask one more question, which data type is not need to use symbol " ", int, real, date ?

kollinaresh.k · February 28, 2011, 4:19am

It is required only for the string data type…for the rest no need to use…

ffchen · February 28, 2011, 4:46am

Thanks Naresh,

I would like to create a method for Date, is any method that when choose Date 10\2\2011, then it will return coming days,

11\2\2011

12\2\2011

13\2\2011

roshankvp · February 28, 2011, 4:53am

Hi Michael,

Directly u can add no.of days to the date

mkdate(10,10,2010)+1;

it gives next day…

if it is not , give me some more expalnation…

kollinaresh.k · February 28, 2011, 5:26am

If you want to increase the date it can be done as suggested by Roshan…

ffchen · February 28, 2011, 6:26am

Hi both,

What I want to do is ,

if I choose any days, it first show the first three date of that month.

For example:

Choose 1/1/2011. then 1/1, 2/1, 3/1 will be shown.

Choose 5/2/2011, then 1/2, 2/2, 3/2 will be shown.

But I dont’t know how to handle it, as the EDT is Date, I could not use substr or make day.

kollinaresh.k · February 28, 2011, 6:53am

I didnt get you what your saying…

ffchen · February 28, 2011, 7:14am