Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds


  Asked By: Stevie    Date: Feb 06    Category: Sharepoint    Views: 1230

how would i return the day of the week or month name rather than a serial number in this calculation?

i have a date column which lists the whole date (date and time)

i then created another couple lookup columns as:

column name "Day of week"
column name "Month"

forgive me i am way more of a systems admin than this kind of thing! in database land i use DAYNAME and MONTHNAME which return words rather than numbers..if this isnt possible then i can always adjust my dts which publishes this list. but then i would have to split results of the query into one that can be the date then another set of columns for returning the names..

*yes there is a calendar view which needs the date column - so i cannot input formatted results into that column, they get turned into the same format no matter what.



1 Answer Found

Answer #1    Answered By: Rashawn Hopper     Answered On: Feb 06

Use the Text function.

Day of the week: = TEXT(Date,"ddd")
Month name: = TEXT(Date,"mmmm")

Didn't find what you were looking for? Find more on Function Or get search suggestion and latest updates.