Group records by Date

Need help Database
1

Anytime I think I have something figured out when it comes to dates I’m shown I’ve not figured it out.

All I’m trying to do is have a RG look at all the records which fall into the search criteria, and then group the dates by days, so I can display the records that fall within that day/date.

I was using extract Date thinking this was looking at the whole date 2/14/2022, but found it was looking at just the day/date. So it was grouping together both 1/14/2022 and 2/14/2022.

Is there a way to get it to group things by a 24 hour period? Once I have a date, I know I can do a search for items in that group by using > and a < +1 day to find dates which fall into that 24 hour period, but how to I initially get a grouping of each 24 hour period?

I’m using this for chat conversations so I’m grouping them into days, so people can see if a conversation was in the past.

@adamhholmes I’ve seen you comment on a lot of forums related to dates. Any thoughts?

Screen Shot 2022-01-28 at 2.16.48 PM
Screen Shot 2022-01-28 at 2.16.48 PM2382×1194 190 KB

2

Yes, ‘Extract Date’ does exactly that - i.e. it extracts the current date (e.g. 15th) as the number 15.

Is there a way to get it to group things by a 24 hour period?

Yes, you can just use ‘Grouped by Date’ in your RG datasource - that will give you groupings by date.

Then you can simply have a nested Repeating Group inside the first one, that searches for messages who’s created date falls on the current cell’s grouping’s date.

3

I feel like I’ve tried that before, but it seems to be working now. Fingers crossed. Thank you.

1 Like
4

Is there a way to scroll to the last message with this implementation and just not the last date? I can’t find a way to scroll inside a nested repeating group…