Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Converting date to month year

I have a list of dates which i have converted to month and year for use in selections within an application.

year(date), month(date) etc.

I was wondering if it was possible to create a combined date/month field for use in selections.

I have tried to convert it using (Date(Date, 'MMM-YY')) as MonthYear, but when creating a list box it has created a MonthYear for every date in that month.

Thanks for any help

1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

Converting date to month year

Use this:

(Date(monthstart(Date), 'MMM-YY'))

1 Reply
erich_shiino
Honored Contributor

Converting date to month year

Use this:

(Date(monthstart(Date), 'MMM-YY'))