[SOLVED] How to achieve relative date (today, yesterday etc)

Yo!

So I had to list down items from the database and have them grouped by Today, Yesterday, Past Days.

The problem: comparing items with date (e.g. created date) and you don’t get a match up because of the time part.

Solution: I created a field of type text and store a copy of the date without the time. I then created a repeating group and get all the unique date text from our new field. After establishing all the dates, I added a new repeating group within the first repeating group to contain the items matching every date text. Additional conditional formatting may be needed for headings on each group (e.g. “Today”, “Yesterday”)

-Clint

2 Likes