date format not accepted in select script

[Anonymous]

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.

[sunny_talwar]

May be try this instead:

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

or

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

[sunny_talwar]

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

Where Num(signed_on) >= 41821;

[qlikviewwizard]

Hi,

Try like this:

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

[jagan]

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'

OR

where signed_on >= '01-JUL-2014'

Regards,

jagan.

[PrashantSangle · Accepted solution]

Hi,

You  required to_char() or to_num()

Date() is QlikView funtion

Regards

[Anonymous]

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