How to Convert Month Name to Month Number in Sharepoint?

Semua Balasan

• 24 Juni 2010 17:58

  Penjawab Pertanyaan

   

   
  

  0

  You can either convert it programatically or you could set the date format for a date field in SharePoint and then assign the value you have to that field and taking the result value from that field.

   

  ---

  I trust that answers your question...
  
  Thanks
  C
  http://www.cjvandyk.com/blog
  • Balas
  • Kutip

   
• 25 Juni 2010 3:32

   

   
  

  0

  Hi Kumar,

  The following the info is from a post by

  Clare Stine http://abstractspaces.wordpress.com/2009/05/02/common-date-time-formulas-for-sharepoint-calculated-fields/

  Get Week of the year
  =DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))+0.5-WEEKDAY(DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])),2)+1

  First day of the week for a given date:
  =[Start Date]-WEEKDAY([Start Date])+1

  Last day of the week for a given date:
  =[End Date]+7-WEEKDAY([End Date])

  First day of the month for a given date:
  =DATEVALUE(“1/”&MONTH([Start Date])&”/”&YEAR([Start Date]))

  Last day of the month for a given year (does not handle Feb 29). Result is in date format:
  =DATEVALUE (CHOOSE(MONTH([End Date]),31,28,31,30,31,30,31,31,30,31,30,31) &”/” & MONTH([End Date])&”/”&YEAR([End Date]))
  Day Name of the week : e.g Monday, Mon
  =TEXT(WEEKDAY([Start Date]), “dddd”)
  =TEXT(WEEKDAY([Start Date]), “ddd”)

  This may give you some ideas...

  -Ivan

  ---

  Ivan Sanders My LinkedIn Profile, My Blog, @iasanders.

  • Ditandai sebagai Jawaban oleh Rock Wang– MSFT 02 Juli 2010 8:58
  •  
  • Balas
  • Kutip

   
• 20 Juni 2012 12:46

   

   
  

  0

  Create a calculated field as Date \ Time.

  enter code: =TEXT([Month]&"/01/"&[Calendar Year],"YYYY/MM/DD")

  [Month] = Full month name ex:  "October"

  • Balas
  • Kutip