Hello everybody, I want to show a list of tasks in my repeating group, showing when the last activity was with this task.
I’m looking for ways to format the date like in the image. If the last activity was today or yesterday, it will be “today” or “yesterday”, in other cases the date will be formatted as DD/MM. Does someone know how I can do this?
If your question is as specific as it seems to be (i.e. you’re just asking about ‘today’, ‘yesterday’ or any other date), then just use 2 conditions on the text element.
If the date, rounded down to day equals the current date/time rounded down to day, then show Today.
If the date, rounded down to day equals the current date/time rounded down to day, minus 1 day, then show Yesterday.
Otherwise, show the date.
1 Like
This is the answer I was looking for. Thanks for contributing!
1 Like
This topic was automatically closed after 70 days. New replies are no longer allowed.