I’m trying to display relatives date/hour (ex. if creation date = current date display: today, if not display day: “5”) but I couldn’t get it. Can someone help me find out?

Well, I got it by making a text “today” hidden to show up when “creation date - current date:formatted as days is 0”. Now I have to do one for “yesterday” and another for display other dates. It would be good to chain some conditions in 1 workflow (if this or else statement)

It’s broken - more days are being considered “today”, trying to find out why

I had to use :extract day on both, now it’s sooo cute :slight_smile: = 0 for today, -1 for yesterday and the image value for all other days [image]

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 t…

Just a update: I don’t use visibility anymore, I just use 1 text element, and in “conditional” tab I use the “text” property to display today, yesterday etc

I have a slightly different version of this, but am also confused by something. I have 2 elements: Text element contains the date in my database that I want to display as Yesterday, Today or Tomorrow depending on today’s date. Input element that is of content format ‘Date’. I use these conditions…

Actually to be complete, this is how I implemented it: [image] I put the input field in the same repeating group is the text I want to manipulate (same initial value) and then hide it.

Does anyone know a solution to mark days older than yesterday? I want to red flag any date that is past the due date + yesterday but the use of < seems to be pretty limited…

[image] vincent56: Does anyone know a solution Got the same issue. Any idea how to delete a listing that is overdue?

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

Questions

lioktabriansyah June 21, 2020, 10:17pm 13

does not work

Topic		Replies	Views
Can you do previous day? Questions	7	1143	April 24, 2019
Best way to calculate dates in conditionals Questions	9	2196	February 23, 2022
Format date for each day Need help	2	167	October 22, 2023
Added Today, Yesterday, 30 days ago Database	4	2345	July 1, 2020
How do i say "today" when constraining DB searches Database	6	726	September 18, 2022

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

Related topics