Thanks Carl.
Both formulas ended up working in SharePoint.
I did later realize that the dates in the list spanned more than two fiscal years so I expanded the formula to fit any date range.
=IF(MONTH([start date])>=7,CONCATENATE("FY",(YEAR([start date])+1)),CONCATENATE("FY",YEAR([start date])))
Hello All,
I am trying to create a calculated column using an existing column that contains dates.
The statement is as follows : IF([start date] > 6/30/2010, "FY11", "FY10")
However, sharepoint does not seem to be reading 6/30/2010 as a date and keeps giving me FY11 as the return value even...
Hello,
I am using a combo box to lookup records in a form based on Vendor ID.
If the user enters a vendor ID that is not in the table the form defaults to the first record in the table.
How can I have the form display a pop-up notifying the user that the Vendor ID is not in the system and...
Hello All,
I am running Office 2007 and can use SUMIFS to sum all IF statements. However, my collegues are running on 2003 - How do I create a similar statement in excel. I have tried using nested IF's but it did not work.
My SUMIFS statement is here: (SUMIFS('Sheet 1'!A:A,'Sheet 1'!X:X,"5...
I do not see the incoming email option in the settings for task lists. Is it possible for users to send documents via email to a project task list in MOSS 2007?
Hello All,
I am trying to move multiple folders that exist in a document library (MOSS 2007) into a new folder created within that same document library.
How can I do this?
Thanks.
I have an excel document containing merged cells. However, when text entered into a merged cell overflows into a larger space than the merged area the cell does not expand. All merged cells are wrapped.
Is there a way to have the merged cells expand when needed?
Thanks.
Hello All,
I have two sections in a five page word document. The footer of the document contains the page number. The first section has three pages and is numbered 1-3 of 3.
The second section is numbered 1-2 of 2. Is there a way I can remove the page numbers from the footer of the second...
Hi,
I have a very complex swim lane diagram in igrafx and re-creating the whole thing in Visio would be a complete waste of time. Is there a way I can convert the igrafx document to a Visio document?
Sotware being used:
iGrafx FlowCharter 2006, Visio Professional 2003
Thanks.
I wanted to add some more information
There are five fields in the table [ItemNumber], [CreateDate], [PONumber], [OpenQty], [Supplier]
In addition to finding the last purchase order created (Max[CreateDate]) for each item is it possible to only return the largest qty if there are more than two...
Hello,
I am working with a purchase order table that has a field called [CreateDate]. Each [ItemNumber] might have multiple purchase orders with a different [CreateDate].
How can I run query to only show the records for the last created puchase order for each item?
Thanks,
cordeiro82
Thanks guys.
I would like to piggyback this question with another one. Now that I have 6 slots for future orders my crosstab looks something like this
Material | Today | 1 | 2 | 3 | 4 | >4
A
B
C
When I try to link...
Hello All,
I have a future orders table that contains a date field [datedue]. The table is refreshed everyday, and the dates begin with the day of the refresh onwards.
I would like to create an additional field that is populated with the following text:
"Today" for min[datedue] (which would...
Hello,
I currently have a Query that calculates the number of days that an order is late using
Now()-[tableX].[DateX]
The problem with this is that the number returned is the count of calendar days and not business days. Is there a way to count only business days (Mon-Fri)?
Thanks,
Cordeiro82
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.