How to Show the Day of the Week?

Hello there,

Can someone help me to show the day of the week in Kintone?

When you enter a date and time, it should automatically display the day of the week as well.

The day of the week can be displayed either in the same field as the date and time or in a separate field.

Regards.

Hello @Mpumuro ,

Check out the Show Day of the Week on Date Fields tutorial to display the day of the week next to the Date field.

show-day-of-the-week-on-date-fields/dayoftheweek.gif

If you need more assistance, please provide more information regarding:

  • Your current situation

  • Your desired outcome

  • What you have tried so far

I hope this was helpful!

Hello Genji,
Thanks for your support

Hello Genji,

I referred to the Displaying the Day of the Week Based on the Date Value article, and I was able to get it working for the date field.

But I could not get it to work for the Date and Time field.

How should I correct my setup?

Kindly

Hello @Mpumuro ,

:warning: The formula used in the Date field and the Date and time field are different.

Formula when using a Date and time field


IF( ( ( (ROUNDDOWN((Date and time+(60 * 60 * 9))/ 60 / 60 / 24) ) - 0) / 7 ) - ROUNDUP(( ( (ROUNDDOWN((Date and time+(60 * 60 * 9))/ 60 / 60 / 24)) - 0) / 7 ) , 0) = 0 , "Thursday",
IF( ( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24) ) - 1) / 7 ) - ROUNDUP(( ( (ROUNDDOWN((Date_and_Time+(60\*60*9))/ 60 / 60 / 24)) - 1) / 7 ) , 0) = 0 , "Friday",
IF( ( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24) ) - 2) / 7 ) - ROUNDUP(( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24)) - 2) / 7 ) , 0) = 0 , "Saturday",
IF( ( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24) ) - 3) / 7 ) - ROUNDUP(( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24)) - 3) / 7 ) , 0) = 0 , "Sunday",
IF( ( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24) ) - 4) / 7 ) - ROUNDUP(( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24)) - 4) / 7 ) , 0) = 0 , "Monday",
IF( ( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24) ) - 5) / 7 ) - ROUNDUP(( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24)) - 5) / 7 ) , 0) = 0 , "Tuesday",
IF( ( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24) ) - 6) / 7 ) - ROUNDUP(( ( (ROUNDDOWN((Date_and_Time+(60 * 60 * 9))/ 60 / 60 / 24)) - 6) / 7 ) , 0) = 0 , "Wednesday","N/A"
)
)
)
)
)
)
)

If the above :point_up_2: formula did not work, please include more information.

To help you, include the following in your questions:

  • Screenshot of your error message
  • Screenshot of your App and field settings
  • Description of your desired outcome
  • Formula used in your Text field
  • Field code for your Date and Time field

Hello Genji,

Thank you for your support.
It is now is working perfectly.

Regards