Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date-time field that I want to group by day in my load script using GROUP BY , however, it is not working properly because of the time portion of the data. I have tried trimming the date using MID or FLOOR but these functions can't be used after the GROUP BY statement.
This is what I have so far but it is not working:
Actual_Dates:
LOAD
Date("Actual OK Date") AS Actual_Date,
Count(Date("Actual OK Date")) AS Count_Actual_Date
FROM [Report.xls]
(biff, embedded labels, table is [Table1])
GROUP BY Date("Actual OK Date");
Try using either Date(Floor("Actual OK Date")) or Date(DayName("Actual OK Date")) instead. Date() doesn't remove the timestamp aspect, it just provides formatting.
Try using either Date(Floor("Actual OK Date")) or Date(DayName("Actual OK Date")) instead. Date() doesn't remove the timestamp aspect, it just provides formatting.
I got it to work with Date(DayName("Actual OK Date")) . Thank you @Or , appreciate it!