Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

alec1982
Valued Contributor II

Date Field

Hi,

I have a date field that looks like:

[End Date]

1-May-2012

3-June-2008

5-April-2007

Tried to format it so i can pull the year by itself but didn't work. Year([End Date])

I tried to do :

Date#([End Date]) as Date,

Date( Date#( [End Date], 'MM/DD/YYYY' ) ) as Date,

Both options didn't work. Any idea?

Thxs for your help,

Alec

1 Solution

Accepted Solutions

Re: Date Field

Hi

Please check the attached file

3 Replies

Re: Date Field

Hi

Please check the attached file

diegofcaivano
Contributor

Re: Date Field

Hi Alec,

The second parameter of the DATE#() function is the mask used to interpret the field value. In your case, it would be:

DATE(DATE#([End Date], 'D-MMMM-YYYY')) AS [End Date]

Regards.

alec1982
Valued Contributor II

Re: Date Field

Thxs guys!

Community Browser