topic date format not accepted in select script in QlikView

date format not accepted in select script

Anonymous — Mon, 12 Oct 2015 02:57:10 GMT

hi,

the following error is displayed when i user this script :-

Error:-

SQL##f - SqlState: 42883, ErrorCode: 7, ErrorMsg: ERROR: function date(date, unknown) does not exist;

Error while executing the query

SQL SELECT

where(date(signed_on ,'DD/MM/YYYY')>= date(date(2014,7,1),'DD/MM/YYYY'))

the dates look like this in the data base:-

2015-08-20 02:30:59.181032

I've also used "makedate" with no luck.

any help appreciated.

Re: date format not accepted in select script

sunny_talwar — Mon, 12 Oct 2015 02:59:20 GMT

May be try this instead:

Where Date(signed_on ,'DD/MM/YYYY') >= Date(MakeDate(2014,7,1),'DD/MM/YYYY');

Where Num(signed_on) >= Num(MakeDate(2014,7,1));

Re: date format not accepted in select script

sunny_talwar — Mon, 12 Oct 2015 03:01:26 GMT

Seems like you are doing this in SQL script. May be try this:

Where Num(signed_on) >= 41821;

Re: date format not accepted in select script

qlikviewwizard — Mon, 12 Oct 2015 03:25:40 GMT

Hi,

Try like this:

Where Num(signed_on)>= num(makedate(2014,7,1))

Re: date format not accepted in select script

jagan — Mon, 12 Oct 2015 03:40:28 GMT

Hi,

Date() and MakeDate() are Qlikview functions, in SQL Query you have to use corresponding function of that database, those functions won't work in SQL Queries.

Try

where signed_on >= '2014-07-01'

where signed_on >= '01-JUL-2014'

Regards,

jagan.

Re: date format not accepted in select script

PrashantSangle — Mon, 12 Oct 2015 03:54:40 GMT

Hi,

You required to_char() or to_num()

Date() is QlikView funtion

Regards

Re: date format not accepted in select script

Anonymous — Mon, 12 Oct 2015 04:06:57 GMT

thanks Max. can you help me with my data not flowing through to my dashboard question please