using dates Part 2

Karl was great in helping me get to this point with dates, now I'm wondering 
if we can take it 1 step further?

For Activity Dates prior to 2/1/2007 they are using a normal reporting year 
and the formulas below take care of Activity dates >2/1/2007?

So for example prior to 2/1/2007
1/1/2006 would have a B_Qtr of 2006-1


1) B_Qtr - 2011-1 --- Format(DateAdd("m",11,[ActivityDate]), "yyyy - q")
2) Year - 2011  ---- Year(DateAdd("m",11,[ActivityDate]))
3) Qtr - Q1  ---- Format(DateAdd("m",11,[ActivityDate]), "q")

-- 
Thank you in advance!!!!
0
Utf
3/26/2010 5:18:01 PM
access.queries 6343 articles. 1 followers. Follow

0 Replies
773 Views

Similar Articles

[PageSpeed] 3

Reply:

Similar Artilces:

Can no longer open Outlook with Business Contact Manager enabled... #2
Hello, Any help will be very much appreciated. I can no longer open 2003 with Business Contact Manager enabled. I have uninstalled and reinstalled BCM and created new (empty) profiles, but nothing works. How can I get BCM to work with Outlook again? Thank you. Regards, Lon ...

Can't login #2
I can log in to my passport account via the web, but starting today, when I fire up Money, it tells me that Money can't verify my login. What gives? The MSN Money web-site is updating. See: http://support.microsoft.com/money -Mark "joealtus" <joealtus@discussions.microsoft.com> wrote in message news:7C42C72C-C1D0-49CC-A421-2EA0714D57CA@microsoft.com... > I can log in to my passport account via the web, but starting today, when I > fire up Money, it tells me that Money can't verify my login. What gives? Thanks - that needs to be reflected better in the error ...

An OLE registration error occured #2
Hi, When I start Outlook 2000, I get the message "An OLE registration error occured. The program is not correctly installed. Run setup again for the program". When I press OK it closes. I tried to repair did not work. I uninstalled it then installed again still not working. Note that I am experiencing some kind of adware/hijacking with internet explorer. Word, Excell and Access work properly. How can I fix the registration error. Thanks for your help. jmassry. ...

synchronize sub forms-part 2
Trying to sync subform records. Used code from my previous question on this subject, but records do not sync until after the record is changed (on navigation bar). I have a main form (frm1) and six sub forms (fsub1-fsub6). In fsub1 On Current Event: Forms![frm1]![fsub2].Requery In fsub2 On Current Event: If IsNull(Forms![frm1]![fsub1].Form!ID) = False Then Me.RecordsetClone.FindFirst "[ID] = " & Forms![frm1]![fsub1].Form!ID Me.Bookmark = Me.RecordsetClone.Bookmark Else Forms![fsub1].SetFocus DoCmd.GoToRecord , , acNewRec End If ...

Upgrade from CRM 1.0 to CRM 1.2
Hi we are new MS Cert Partner and just recived our action pact, it had CRM 1.0, we need 1.2 . Any thoughts ? call MS CRM sales at 800 456 0025 your account number is the phone number you registered the license under. They will ship one out but they are backordered till the end of Jan. They may also issue 1.2 keys as well. HTH GP "Phillip" <anonymous@discussions.microsoft.com> wrote in message news:61fe01c3e5d9$366330c0$a501280a@phx.gbl... > Hi we are new MS Cert Partner and just recived our action > pact, it had CRM 1.0, we need 1.2 . > Any thoughts ? ------=_...

use multiple worksheets
I have a spreadsheet with 12 worksheets, one for each month. I would like to have cell names on each sheet that are identical to the others. I was able to create one sheet and then copy it entirely and the cells names copied properly, however, now I need to add new information, with new cell names and when I try to copy that portion of the worksheet to another, the name references change and won't be absolute to each worksheet. Help Please! Mike on the sheet you want to copy from do edit>replace, replace = with r= (replace the equal sign with lett_equal sign), that makes t...

How do i create a macro using copy
Hi, I would like to know how do i create a macro the will copy what i have in cell A1 or inputbox and search it for me. Eg. Cell A1 consist of text "Apple" when click on the button, it will find Apple. If it is "Orange" it will find orange. I do remember creating it once but have forget about it. Any advise. Thanks Try Sub Macro() Dim varFound As Variant, varSearch As Variant varSearch = Range("A1") Set varFound = Cells.Find(varSearch, _ After:=Range("A1"), LookIn:=xlValues, lookat:=xlWhole) If varFound.Address <&g...

How do set up brochures on 8 1/2 x 14 paper
How do I set up a 4 panel brochure on 8 1/2 x 14 paper (landscape) in Publisher? Setup your printer first, if your printer doesn't say 8.5 x 14 it may have legal which is the same. If you are using a brochure template, once you select the template change the printer setup to legal, Publisher will automatically change the brochure to the correct size. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "TracksAll" <TracksAll@discussions.microsoft.com> wrote in message news:02E934C1-5FA1-44D3-9F03-78AC8F2B1ECB@micr...

Copying filtered data using advance filter to another sheet
Hi All Can anybody tell me how to copy filtered data usiing advance filter to another worksheet (not the one containing list) Thanks Bandula Hi, you could start from the other sheet and then copy the list when you filter or you could select the filtered list. Press F5, click Special and select visible cells, copy and paste.. Regards, Peo Sjoblom >-----Original Message----- >Hi All > >Can anybody tell me how to copy filtered data usiing >advance filter to another worksheet (not the one >containing list) > >Thanks Bandula >. > ...

Text Box #2
Besides some other strange problems with Publisher 2007, now whenever I use the text box, there's a round circle with 4 small lines sticking out of the circle. I can't delete the 'symbol' without deleting the whole text box! Used to work correctly before I had to re-install. Used to just have a clean empty text box. Now there's this round symbol in it. Help! Are you using the trial version? Do a detect and repair from the help menu. Can you do a print screen and send me the result? mary-sauer at columbus.rr.com -- Mary Sauer MSFT MVP http://office.microsoft.com...

news groups #2
I switched from outlook express to outlook and my new groups disappeared. Can I only use that in express? Correct, newsgroup chores are still handled by Outlook Express. "theresa" <theresa@discussions.microsoft.com> wrote in message news:7BFB6370-99AA-4C05-8377-84EFFF849BF1@microsoft.com... >I switched from outlook express to outlook and my new groups disappeared. >Can > I only use that in express? "theresa" <theresa@discussions.microsoft.com> wrote in message news:7BFB6370-99AA-4C05-8377-84EFFF849BF1@microsoft.com... >I switched from outlo...

Minor Loss of Fidelity #2
Hi All, Ok, Excel 2007. Must be a format colour translation problem. Saving to .xls. Even if I close the file and re-open, on the next Compatibility Check it still says "Minor Loss of Fidelity". There is no Goto or Find hyperlink. It's not my file and it's a large file. Are there any ways to sniff out which cell(s) are causing this issue? Thanks in Advance. Did you ever find anything out? I'm having the same problem... anyone? "AnandaSim" wrote: > Hi All, > > Ok, Excel 2007. Must be a format colour translation problem. Saving > to .xls. Even i...

GP 9.0 user logins passwords
We have this same problem, but only for a few users. A user will be told that their GP password is not valid for FRx, so the SQL admin will reset the FRx password. This allows the user to log into FRx, but on the next log in for GP, GP forces the user to change their password. Once the GP password is changed (so the user can get into GP), the FRx password again is locked and needs to be reset by the SQL admin. It is a vicious circle, so any help on this will be greatly appreciated. Again, it is strange because half of the users have no problem at all. TIA ryanb. ==== Newsgroups:...

Forcing Workbook to Maximize #2
Thanks Dave...I'll take a look when I get a chance -- Llobi I am a Technology Specialist and District WebMaster for a schoo district in Texas ----------------------------------------------------------------------- Llobid's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=777 View this thread: http://www.excelforum.com/showthread.php?threadid=31407 ...

Using wildcards in CString::Find() #2
Using wildcards in CString::Find() I’d like to use the wildcards(" * ", " ? " and other) in CString::Find(), but it does not work. Always it returns -1. Could you advice me ? I must do the complicated searching. Maybe there are other ways for the substring searching . Alur. ...

Copy Partial Cell Contents in Excel ? #2
I will definitely work through those responses and give them a try! Los this thread for a little while, but FOUND it again! Thank you very muc for your help Sirs! Best, Ma -- MacDubhga ----------------------------------------------------------------------- MacDubhgal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1424 View this thread: http://www.excelforum.com/showthread.php?threadid=25899 ...

Using an html signature
My partner has started a new job and has been emailed an html file of the email signature she should use. Consulting emails from other employees of the company, I see that this consists of a logo and personal information at the TOP of the email, with a standard disclaimer appearing BELOW the body text. I've opened the html file in Explorer, copied the contents and pasted them into a new signature, but this places the signature below the insertion point. I can reposition the insertion point between the signature block and disclaimer, but this is fiddly and means for each new e...

Delete PO using Econnect
Hi, I am trying to delete a PO using econnect but when i try to send the XML i get the following error: Microsoft.GreatPlains.eConnect.eConnectException: Sql procedure error codes returned: Error Number = 2969 Stored Procedure taPopPoDelete Error Description = PO Status is not NEW, PO can not be deleted Node Identifier Parameters: taPopPoDelete PONUMBER = PO00013400 <taPopPoDelete><PONUMBER>PO00013400</PONUMBER><RequesterTrx>0</RequesterTrx></taPopPoDelete> ---> Microsoft.GreatPlains.eConnect.eConnectExcept...

Use this critical package from Microsoft Corporation
--loqupmfieinxbpmz Content-Type: multipart/related; boundary="equgsnfuxtguux"; type="multipart/alternative" --equgsnfuxtguux Content-Type: multipart/alternative; boundary="xgzsfgnzvgjkbv" --xgzsfgnzvgjkbv Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Client this is the latest version of security update, the "September 1997, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install...

splitting contents of a cell #2
Hi all, I have a list of addresses split over five or so columns. One of the columns has the format "# street name". Is it possible to write a formula that lifts the street name out of that cell but not the number? so from a cell with "25 Hight Street" I would want just "High Street". hope that makes sense, thanks, luc if cell A1 has 25 HIGH STREET, the following formula in B1: =RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) will extract HIGH STREET. -- icestationzbra ------------------------------------------------------------------------ icestationzb...

Bloomberg Ticker
Hello, Does anyone know the Bloomberg Ticker to access historical data for SPI futures that were traded on the Sydney Futures Exchange prior to 2000? I am aware that the current code is XPA, however, there is no data prior to 2000. Cheers Mark ...

handle #2
Hi, How should i get the handle of the print dialog that comes up when i print a file using ShellExecutEx()...? "gshetty" <gshetty85@gmail.com> wrote in message news:1193068049.692260.78380@q3g2000prf.googlegroups.com... > Hi, > > How should i get the handle of the print dialog that comes up when i > print a file using ShellExecutEx()...? > There's no straightforward way to get it, but this is a reasonable hack: Use Active Accessibility (SetWinEventHook) to be notified of new window creations, and identify the print dialog with either the classname or...

Search Folders #2
Dear Sirs, I have created a search folder to search a public folder in a general public folder tree, unfortunately newly added items to the search folder are not searched even after this public folder is indexed till the search folder is deleted and recreated. What could I be doing wrong? Regards, Yahya ...

Date() not functioning as expected
Hi, I'm working with Access 2003 at work, and we have reports that show projects with all associated milestones, and employees are supposed to enter the date of completion when the milestone is met. One of our reports is called 'Missing Dates', and it returns a list of all projects with associated milestones ONLY if there is a proposed milestone date between 1/1/2001 and the current date. The funtion is currently set up as Between #1/1/2001# And [Enter Date mm/dd/yy]. This works perfectly. I'm trying to get it where the user doesn't even have to enter the cu...

Calculation Speed #2
I am having a lot of trouble with increasing the speed of my workbook calculations. I have queries, outside links and many INDEX and MATCH formulas that I do not want to eliminate. After I run a query and have the main page of the workbook calculate, is there any way that I can continue to calculate the rest of the workbook without the main page recalculating? All of the worksheets rely on the main page and some of the worksheets rely on other pages as well. Therefore, calc sheet is not thorough enough. I need to calculate entire workbook except certain pages. I am wondering if ge...