
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Group by day using date-time field
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");
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I got it to work with Date(DayName("Actual OK Date")) . Thank you @Or , appreciate it!
