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