Where condition for single date

[#1]

Hi

In my current working QVW file having a Qvd that contains a field of "CapDateTime".

CapDateTime:

01-09-2011 01:39:40

02-09-2011 12:14:30

02-09-2011  03:24:10

03-09-2011 11:44:21

and so on...

Now

I am trying to do like below format, but it is not fetching any lines for the application.

Test1:

Load  *

From C;\OrigianlData.qvd(qvd)

Where CapDateTime = 02-09-2011

;

Where i had done mistake in above script.

Thanks

[SunilChauhan]

Load  *,

1 as junk

From C;\OrigianlData.qvd(qvd)

Where CapDateTime = 02-09-2011

while take resident it needs to add one more column

[kaushiknsolanki]

Hi,

    Try this.

    Test1:

     Load  *,

     From C;\OrigianlData.qvd(qvd)

     Where date(CapDateTime) = date(date#('02-09-2011','DD-MM-YYYY'),'DD-MM-YYYY');

Regards,

Kaushik Solanki

[#4]

Hi,

You can try keeping the where clause as follows..

where date#(left(CapDateTime,10),'DD-MM-YYYY') ='03-09-2011';

Cheers.

[its_anandrjs]

Hi,

You have to write some thing like below

Test1:

Load  *

From C:\OrigianlData.qvd(qvd)

Where Date( Left ( CapDateTime,10), 'DD-MM-YYYY' )  = ' 02-09-2011';

Which is based on your original post you miss : on that and you put ; in place of :

HTH

Rgds

Anand