Where Conditions

[#1]

Hiya,

Can anyone tell me where I'm going wrong at the end of my query I am using the following where clause:

Where usage_date > (date(today()-31,'DD/MM/YYYY'))

and usage_date < date(today(),'DD/MM/YYYY')

and Not  isnull(usage_date)

It is failing on the second line, the error it is giving me is field "and" not recognised :S ???!!!

[puttemans]

I'd play around with the brackets

Where (usage_date > (date(today()-31,'DD/MM/YYYY'))

and usage_date < date(today(),'DD/MM/YYYY')

and Not  isnull(usage_date))

[Anonymous]

Post your full query .

[Digvijay_Singh]

Looks like you got extra bracket after first condition..

[Digvijay_Singh]

Oh, missed that, there is one before date as well.

[#6]

thanks I hadn't spotted that

I tried again with this script, still same error 😕

QualifY *;
Unqualify clarapw_id;
CARE:
Load
DateTime,
clarapw_id,
usage_date,
bytes_downloaded,
bytes_uploaded
Resident clarapw_usage

Where usage_date >  date(today()-31,'DD/MM/YYYY')

and usage_date < date(today(),'DD/MM/YYYY')

and Not  isnull(usage_date)

Order by usage_date asc;

[Anonymous]

Hi,

Try:

Where usage_date > date(today()-31,'DD/MM/YYYY')

and usage_date < date(today(),'DD/MM/YYYY')

and Not  isnull(usage_date)

[Anonymous]

Hi Sarah,

What is usage_date  format?

Regards

Neetha

[Peter_Cammaert]

Still works ok in any other document.

Clear the LOAD statement and write it again. Maybe some invisible text character is having fun with you.

Peter

[sasiparupudi1]

please attach your application