Do you know how to format dates to include the weekday?
Last updated by Unknown over 13 years ago.See historyFigure: Bad example - using the default Date Format
Figure: Good example - using the Date Format with 'ddd'
How do you do this ?
By default, the date type column only have two format options:
Figure: Date Format #1 **Figure: Date Format #2 ** To add the week day(eg.Wed) you need to:
- Select List Settings | Columns |Create column | Calculated (calculation based on other columns)
- See the columns of this list in the "Insert Column", add the column you want to change format, and custom the code in "Formula" like below: Figure: Calculated column with Formula code
- Change the views of the list to use the new Calculated column (WeekDate) instead of the original date column (Date): Figure: Replace the old Date column (Date) with new Calculated column (WeekDate It should not be this hard - see suggestion to the SharePoint team to make date formatting easier.
Love it
0
Agree
0
Disagree
0
No way
0