From tutorial, Year/Month coming up empty

[#1]

Hi all. Trying to get through the getting started tutorials, but am having some problems. I am following the steps exactly as they are provided. However, in the tutorial video the added rows (Year & Month) are filled with years and months when "Select field...". My fields "Year" & "Month" are however empty.

The [Invoice Date] does contain alot of dates, so probably shouldn't have anything to do with that (?).

I'm completely new with QV, so please bare with me [:)]

Thanks!

Code:

[Invoice Date],
Year ([Invoice Date]) as Year,
Month ([Invoice Date]) as Month,
[Invoice Number],

[#2 · Accepted solution]

I think, the problem is, that your system date format does not correspond to the date format which has been used in QlikView.

Maybe you try something like

date(date#([Invoice Date],<Dateformat>))

instead of [Invoice Date].

You must enter something like 'YYYY-MM-DD' for <Dateformat> depending on the output you see for Invoice Date.

example:

date(date#([Invoice Date],'YYYY-MM-DD'))

Hope this helps.

[#3]

and maybe

date#([Invoice Date],<Dateformat>)

is enough...

I don't know really. You have to try and play a little bit with the date function (date()) and date conversion function (date#())

[#4]

Have the same issue,

whats the solution?

[#5]

"I think, the problem is, that your system date format does not correspond to the date format which has been used in QlikView."

[#6]

Is it possible to se my system date format ?
Can i Change it or can I write the code differently?

no of the above examples works.

/e

[#7]

Simply, show the date field in the QV application. Then you should see the full date string as read from database

[#8]

I have

SET DateFormat='YYYY-MM-DD';

Invoice Date looks like this

13/12/2007

But I cant change the dateFormat variable (still no data).

Year ([Invoice Date]) as Year

/e