Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Convert DD/MM/YYYY table to Day, Month and Year Fields

Hi

Ive just started creating dashboards and wondered if there is a easy way to convert data thats in DD/MM/YYYY format to individual Day, Month and Year fields?

Thanks in advance

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: Convert DD/MM/YYYY table to Day, Month and Year Fields

In a preceding LOAD to your SQL Select statement, you can use all QV date and time functions available, so something like this should do what you want:

LOAD [Date logged],

  day([Date logged]) as Day,

  month([Date logged]) as Month,

  year([Date logged]) as Year;

SQL SELECT `Date logged`

FROM `dbo_ProbList`;

2 Replies
MVP
MVP

Re: Convert DD/MM/YYYY table to Day, Month and Year Fields

In a preceding LOAD to your SQL Select statement, you can use all QV date and time functions available, so something like this should do what you want:

LOAD [Date logged],

  day([Date logged]) as Day,

  month([Date logged]) as Month,

  year([Date logged]) as Year;

SQL SELECT `Date logged`

FROM `dbo_ProbList`;

Not applicable

Re: Convert DD/MM/YYYY table to Day, Month and Year Fields

Thank you for the quick response, That worked perfectly!!

Community Browser