<div>
<div class="content wysiwyg-content">
I have the following formula in SharePoint calculated field in a list. This one determines the Quarter based on the month in Deployment Start Date. Now I want to include in the formula<br />
that if Deployment Start Date is past the Current Date or System Date then use a different date called Deployment End Date. How to include that in the below formula?<br />
<br />
<br />
=IF([Deployment Start Date]=0,0,(CONCATENATE(RIG<wbr />HT(YEAR([D<wbr />eployment Start Date]),2),&quot;Q&quot;,IF(MONTH([De<wbr />ployment Start Date])&lt;=3,1,IF(AND(MONTH([<wbr />Deployment<wbr /> Start Date])&gt;=4,MONTH([Deploymen<wbr />t Start Date])&lt;=6),2,IF(AND(MONTH(<wbr />[Deploymen<wbr />t Start Date])&gt;=7,MONTH([Deploymen<wbr />t Start Date])&lt;=9),3,IF(AND(MONTH(<wbr />[Deploymen<wbr />t Start Date])&gt;=10,MONTH([Deployme<wbr />nt Start Date])&lt;=12),4,0)))))))<br />
<br />
<br />

</div>
</div>


I have the following formula in SharePoint calculated field in a list. This one determines the Quarter based on the month in Deployment Start Date. Now I want to include in the formula
that if Deployment Start Date is past the Current Date or System Date then use a different date called Deployment End Date. How to include that in the below formula?


=IF([Deployment Start Date]=0,0,(CONCATENATE(RIGHT(YEAR([Deployment Start Date]),2),"Q",IF(MONTH([Deployment Start Date])<=3,1,IF(AND(MONTH([Deployment Start Date])>=4,MONTH([Deployment Start Date])<=6),2,IF(AND(MONTH([Deployment Start Date])>=7,MONTH([Deployment Start Date])<=9),3,IF(AND(MONTH([Deployment Start Date])>=10,MONTH([Deployment Start Date])<=12),4,0)))))))




How to check in the existing formula in SharePoint calculated field and check the date field against current date

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.

Microsoft SharePoint

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

InfoPath

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.