Between function in where clause+load csv file

[#1]

Hi,

I have a load statement and my problem is that when I load a csv file, the Between And statement in my where clause are treated as garbage..

is there any other way so that I can use date range in my script..

Here's the script:

LOAD [User ID],

[First Name],

[Last Name],

Department,

date(date#(Date,'YYYY/M/D')) as LogDate,

Time,

Event,

Terminal,

Remark

FROM

\\Phoenix\Qlik\report.csv

(txt, utf8, embedded labels, delimiter is ',')

Where Date Between $(vFromDate) AND Date <= $(vToDate);

[maneshkhottcpl · Accepted solution]

Hi,

You cannot use the between function in load statement, it is belongs to SQL.

instead of it u can use AND statements.

[#3]

Hi

as manesh said true...

u can use the where clause to load the data as like

Where Date >= $(vFromDate) AND Date <= $(vToDate);

or

Where Date >= '$(vFromDate)' AND Date <= '(vToDate)'

[#4]

I tried that. but throwing error about Date and Varchar conversion issue.

[#5]

I tried that. but throwing error about Date and Varchar conversion issue.

[#6]

Atlast I have resolved my issue . The script goes like this:

Where (modifiedTimeStamp >= {d '$(StartDate)'} AND modifiedTimeStamp < {d '$(EndDate)'});

The Script works.