Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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`;
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`;
Thank you for the quick response, That worked perfectly!!