topic Re: Calendar Year problem in QlikView

Calendar Year problem

Fri, 04 Apr 2014 15:03:37 GMT

I have a strange problem with the date and the exact year of field. I have the declaration date:

SET DateFormat='YYYYMMDD';

....

SQL SELECT F7000 as Data

FROM DataBase.dbo."TEST_0000";

the date is displayed correctly, unfortunately, in the calendar control in the list is the wrong value. What could be the problem?

yduval75 — Fri, 04 Apr 2014 15:10:56 GMT

If you use it, you have the same problem ?

LOAD

Date(F7000) as Date;

SQL SELECT F7000

FROM DataBase.dbo."TEST_0000";

Fri, 04 Apr 2014 15:16:02 GMT

No it does not work

maxgro — Fri, 04 Apr 2014 20:00:28 GMT

I get your same result

but It seems you can solve it with the bold part (see attachment)

SET DateFormat='YYYYMMDD';

....

load

Data,

date(Date#(Data)) as Data1;

SQL SELECT F7000 as Data

FROM DataBase.dbo."TEST_0000";

whiteline — Sat, 05 Apr 2014 18:04:20 GMT

Hi.

Nice case.

The QV here assumes that F7000 field is just a number regardless of DateFormat settings.

Seems it's better than try to treat every suitable number as date.

In such cases there is no hope that QV will parse the timestamps implicitly.

its_anandrjs — Sat, 05 Apr 2014 18:25:30 GMT

Convert your date field into another resident

Date#(Date,'YYYYMMDD') as Date

Date(Date#(Date,'YYYYMMDD'),'YYYYMMDD') as Date

Hope this helps