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

[#1]

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

[swuehl · Accepted solution]

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`;

[#3]

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