Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Function

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

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"
=WEEKDAY(Date)
column name "Month"
=MONTH(Date)

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.

Share: 

 

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.




Tagged: