Option to show real dates instead of relative dates like "tomorrow" | Consistent due date display | Voters

Option to show real dates instead of relative dates like "tomorrow" | Consistent due date display

Raiden Frunk

The option to switch date displays to exact dates. So instead of "1 day ago" it will display the date you set.

February 14, 2020

Andy Lin

Until this is implemented, this Google Sheets formula can help convert a relative date to an absolute date. The two cells the formula references are:

$A$1:
Date the data was copied
A2:
Date from ClickUp

=IF(A2<>"",IF(ISNUMBER(A2),A2,IF(ISNUMBER(SEARCH(" days ago",A2)),$A$1-LEFT(A2),SWITCH(A2,"Yesterday",$A$1-1,"Today",$A$1,"Tomorrow",$A$1+1,WORKDAY.INTL($A$1,1,MID("1111110111111",MOD(8-MATCH(A2,ARRAYFORMULA(TEXT(SEQUENCE(7),"dddd")),0),7)+1,7))))),)

For Excel, just remove the ARRAYFORMULA function.

This is something I cobbled together quickly, so if anyone has a shorter formula, I'd love to see it.

Paul Walsh

Please please please could this be implemented? It adds a lot of friction to have to figure out the date each time. It's fine for todos but when using it more as a database, the actual date would make life a lot easier.

Jennifer Blackman

Please allow the option for actual dates, not words

Jo Ann Woodcock

I would love to be able to choose relative dates or exact dates by space.

Isaac Nip

lol the post is 4 years ago and this proposed setting is still not yet finished.

This "Tomorrow", "1 day ago" are really annoying. How could clickup not listen to the community?

Luci N.

Merged in a post:

Change time phrasing 'hour ago' to normal time stamp

Thijs Vernooij

Can ClickUp please make a setting, we can choose a preferred time stamp phrasing?
Instead of '1 hour ago' i want to have the exact time there.
05-11-2024 14:35
I just dont understand why software tools like this use the "ago" timestamp phrasing. It's useless because when you see this you actually knows nothing.

November 5, 2024

Ken Grant

Using a formula custom field is a lame-duck workaround. Something like CONCATENATE(DAY(field("Due date”)), "/", MONTH(field(“Due date”)), “/”, YEAR(field(“Due date”))) will give you a date that looks correct and may copy okay but it's now text so doesn't sort properly. (It sorts 1/1/2024, 10/1/2024, 11/1/2024, 12/1/2024, 2/1/2024, 3/1/2024, etc)

Andrew Sutton

And if this could be changed for a specific view rather than site wide, that'd be ideal.

Veronika Cervenakova

please give option to either show real dates or relative dates. different people have different preferences, but there should be an option...

Becky Rittenhouse

+1 relative dates are frustrating

→