Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load *,
1 as junk
From C;\OrigianlData.qvd(qvd)
Where CapDateTime = 02-09-2011
while take resident it needs to add one more column
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
Hi,
You can try keeping the where clause as follows..
where date#(left(CapDateTime,10),'DD-MM-YYYY') ='03-09-2011';
Cheers.
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