CODEWITHSUNDEEP
stringsharepointsharepoint-2013calculated-columns
user3062674
user3062674

Reputation: 1

Sharepoint Calculated Column Outputting string;# before result

I'm outputting a calculated column in a blog archive webpart in sharepoint 2013 in the format of 'MMMM, YYYY' so Im getting a list of dates...however each one has 'string;#' before it...is there anyway to remove this? Ive been looking for a answer for ages.

Example:

string;#November, 2013
string;#October, 2013
string;#November, 2013

Upvotes: 0

Views: 1193

Answers (1)

Prachi Mishra
Prachi Mishra

Reputation: 98

Try this:-

=SUBSTITUTE([Date Column],"string;#","")

Upvotes: 0

Related Questions