Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Date Problem

Hi guys,

I am working from a csv file and I have a field that I want to use as a date.

I have tried about everything to make it display correctly as MMM-YYYY but it displays wrong always. I have used date, date# and other functions. It comes up with a date that does not exist yet Aug-2450. I have also attached the file I am loading from.

Please I need help a.s.a.p to continue my development as it should display as May-2011 or Apr-2011.

Thanks

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Date Problem

The YEAR_MONTH field has data is this format: 201105

When reading the data, you could try something like this:

Makedate(left(YEAR_MONTH,4),right(YEAR_MONTH,2),1) as YEAR_MONTH

2 Replies
mwoolf
Honored Contributor II

Date Problem

The YEAR_MONTH field has data is this format: 201105

When reading the data, you could try something like this:

Makedate(left(YEAR_MONTH,4),right(YEAR_MONTH,2),1) as YEAR_MONTH

Not applicable

Date Problem

Thanks a lot.

It is working now

Community Browser