Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Super simple I think....how to change the way a date is displayed to include weekday?

Avatar

Level 9

I want to change our current date format:

1/11/22 1:15 PM

to

Tue 01/11 1:15 PM (or)

T 01/11/22 1:15 PM

Basically, I want to display the weekday in the start on / due on column as we're getting a lot of struggles understanding why the dates are different when passing over a holiday or a weekend.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

5 Replies

Avatar

Level 9

Thanks Skye! It's close, but the existing format is super long. I was hoping to get the Wed with the short date, otherwise its a Wed, Jan 05 2022 5:00 PM which can take up valuable space.

Is there a way to force it to be Wed, 01/05 5:00P for example?

Avatar

Level 9

Actually, I think I need to create a calculated field that says:

planned start date

day of week = 1-7

If day of week is 1, replace with SUN, if day of week is 2, replace with MON

and then somehow concat it to be

replaced day of week, MM/DD as the display

Avatar

Community Advisor

I just did this sort of thing in a task form. It isn't exactly what you're asking but you can re-use the code I presume.

CONCAT(CASE(DAYOFWEEK(CLEARTIME(Planned Completion Date)),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"),", ",DAYOFMONTH(CLEARTIME(Planned Completion Date)),", ",CASE(MONTH(CLEARTIME(Planned Completion Date)),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),", ",YEAR(CLEARTIME(Planned Completion Date)))

CASE operator matches DAYOFWEEK (0, 1, 2, 3, 4, 5, 6) to the list that follows. Same with DAYOFMONTH.

Here's the time as well:

CONCAT(HOUR(Planned Completion Date),":",MINUTE(Planned Completion Date))

Avatar

Community Advisor

Nice one Randy: it's in the vault! Thanks for sharing!

Regards,

Doug