http://community.qlik.com/

[#1]

Hi! I have a doubt. I would like to view a previously loaded table. The instructions I use are the following:

TBCancel_Or_Correct_SPSH:

LOAD COUNT(*)

RESIDENT TBSPSH

WHERE REVDATE BETWEEN

TO DATE ('$(INIFECHA_VAR)','MM/DD/YYYY') AND TO DATE('$(FINFECHA_VAR)','MM/DD/YYYY)

I mark a syntax error

Please support me with the solution

[deepakk]

hi Maya,

the To Date field need to be in [ ] bracket like below.

[TO DATE].

In Qlikview when ever a space is used between fields then it should be put under [ ] brackets.

[Anonymous]

It is Oracle syntax: TO_DATE
(no space but rather underscore)

[Oleg_Troyansky]

To continue Michael's line of thought - you can't use Oracle functions, or any other SQL functions, in QlikVIew LOAD statements, except for those functions that happen to be common between SQL and QlikView.

If you need to convert a string into a date field, you should use QlikView function DATE#(). Also, I don't think that SQL operator BETWEEN is supported in QlikView - replace it with the pair of "<=" and ">="