<div>
Hi,<br />
<br />
this formula for the calculated field should do the trick:<br />

<pre><code id="code-20-38896091-1">=IF(ISBLANK([Report Date]),&quot;&quot;,TEXT(DATE(YEAR([Report Date]),MONTH([Report Date]),1),&quot;mmm-yyyy&quot;))</code></pre>
<br />
Sorry, I have no MOSS2007 at hand to verify for 100% but at least it works on SharePoint 2010.<br />
<br />
Sample formulas:<br />
<a href="http://msdn.microsoft.com/en-us/library/bb862071(v=office.12).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/bb862071(v=office.12).aspx</a><br />
<a href="http://office.microsoft.com/en-001/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx" rel="ugc">http://office.microsoft.com/en-001/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx</a><br />
<br />
HTH<br />
Rainer
</div>


EEMonthCalc.png

<div>
<div class="content wysiwyg-content">
In a calculated field, I am trying to convert a date field [Report Date] to MMM - YYYY was thinking this would work but I am getting an error.<br />
&nbsp;<br />
=TEXT([Report Date];&quot;mmmm&quot;)&amp;&quot; - &quot;&amp;TEXT([Report Date];&quot;yyyy&quot;)<br />
&nbsp;<br />
I even tried just =TEXT([Report Date];&quot;mmm&quot;)<br />
<br />
The formula contains a syntax error or is not supported. &nbsp;<br />
<br />
Is there a place online that gives all the options for calculated fields and how to do....<br />
<br />
Thanks
</div>
</div>


In a calculated field, I am trying to convert a date field [Report Date] to MMM - YYYY was thinking this would work but I am getting an error.
 
=TEXT([Report Date];"mmmm")&" - "&TEXT([Report Date];"yyyy")
 
I even tried just =TEXT([Report Date];"mmm")

The formula contains a syntax error or is not supported.  

Is there a place online that gives all the options for calculated fields and how to do....

Thanks

Hi,

this formula for the calculated field should do the trick:
(CODE)

Sorry, I have no MOSS2007 at hand to verify for 100% but at least it works on SharePoint 2010.

Sample formulas:
http://msdn.microsoft.com/en-us/library/bb862071(v=office.12).aspx
http://office.microsoft.com/en-001/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx

HTH
Rainer

Using SPD 2007 trying to get MMM - YYYY out of date

In a calculated field, I am trying to convert a date field [Report Date] to MMM - YYYY was thinking this would work but I am getting an error.
 
=TEXT([Report Date];&quot;mmmm&quot;)&amp;&quot; - &quot;&amp;TEXT([Report Date];&quot;yyyy&quot;)
 
I even tried just =TEXT([Report Date];&quot;mmm&quot;)

The formula contains a syntax error or is not supported.  

Is there a place online that gives all the options for calculated fields and how to do....

Thanks

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.