Calculated columns - How to get weekday from a datefield
Hi, I'm experiensing something very weird. I have a simple list with a column called "Date" which display a date as "date only". I want to created a calculated column displaying the weekday as text of the first column. In Sharepoint 2010 i would do it like this: TEXT([Date],dddd) However when doing the same in 2013 it tells me something is wrong with the syntax. ULS Viewer is not much helpfull either. Anyone have any ideas what goes wrong? Thanks
November 22nd, 2012 8:54am

can you try ; instead of , =TEXT([Date];dddd)/blog twttr @esjord
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2012 9:00am

Jan, I tried what you had mentioned it worked for me, however even this worked for me =TEXT(Date,"dddd")Raghavendra Shanbhag | Blog: http://moss-solutions.blogspot.com Please click "Propose As Answer " if a post solves your problem or "Vote As Helpful" if a post has been useful to you. Disclaimer: This posting is provided "AS IS" with no warranties.
November 22nd, 2012 9:12am

Ty sir - this worked!
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2012 9:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics