Sql command issue in qlikview

[bhavvibudagam]

Hi,

I have the below script.When I reload I am getting the error as shown in the image.Please help me to do

ODBC CONNECT TO [PDRMSBKUP;DBQ=PDRMSBKUP ] (XUserId is KMAKLZVNTTcKGYdNSDdcC, XPassword is bDaIOZVNTTcKGYdNSDdKL);

TTTT:

LOAD *;

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= $(vPDRMSBKUP_LWMAIN_RecentDate) ;

Thanks !

[Anonymous]

try enclose right Expression by '

FROM LEADS.LWMAIN WHERE MODTIME >= '$(vPDRMSBKUP_LWMAIN_RecentDate)';

[bhavvibudagam]

Tried but getting error as not a valid month.HELP ME TO RESOLVE.

[susovan]

Hi,

You can also try the attached example process.

Table1:

LOAD Product,

    Amount

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1) Where Product='BIKE';

[jpenuliar]

Is MODTIME  date type field? you probably need to use of Date formatting functions to match the expected parameter.

Try TO_DATE()

[bhavvibudagam]

I am looking for giving Where condition in SQL Table.

[adamdavi3s]

You need to check the oracle session date format, google is your friend here:

http://stackoverflow.com/questions/12603975/oracle-not-a-valid-month

Please remeber to mark this answer has helpful or correct if it has been helpful or answers your question

[bhavvibudagam]

Hi,

I have attached the MODTIME Filed. below is my script.Can you please help me how to use TODATE() In my script.

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= $(vPDRMSBKUP_LWMAIN_RecentDate) ;

Thanks,

[jpenuliar]

Hi Bhavi,

try below:

SQL SELECT *

FROM LEADS.LWMAIN WHERE MODTIME >= TO_DATE('$(vPDRMSBKUP_LWMAIN_RecentDate))', 'DD/MM/YYYY HH:MI:SS');

[bhavvibudagam]

Thanks for you help,

but its not working can you please help me how to convert 10/16/2002 2:44:08 PM to number series (4328.5984) in Sql.