Group by day using date-time field

[alvarezog]

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");

[Or · Accepted solution]

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.

[alvarezog]

I got it to work with Date(DayName("Actual OK Date")) . Thank you @Or , appreciate it!