Super simple I think....how to change the way a date is displayed to include weekday? | Community
Skip to main content
Christina_Jarosz
Christina_Jarosz
Level 9
January 4, 2022
Question

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

  • January 4, 2022
  • 3 replies
  • 850 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

skyehansen
Community Advisor
skyehansenCommunity Advisor
January 4, 2022

Just gave Jill Ackerman the answer in this post: https://one.workfront.com/s/question/0D54X00007C58pCSAR/default-time-on-project-due-dates

Christina_Jarosz
Christina_JaroszAuthor
Level 9
January 5, 2022

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?

Christina_Jarosz
Christina_JaroszAuthor
Level 9
January 5, 2022

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

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
January 6, 2022

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))

    Doug_Den_Hoed__AtAppStore
    Community Advisor
    Doug_Den_Hoed__AtAppStoreCommunity Advisor
    Community Advisor
    January 6, 2022

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

    Regards,

    Doug

    Terms & ConditionsAccessibility statement

    Loading footer...