Can I change the calendar year beginning date?
Our fiscal year runs July 1 thru June 30 of each year. I need to track
attendance, gas cards, etc for monthly reports. I have a HUGE table with a
gazillion queries and reports for each one. I need one report to reflect
quarterly output for our fiscal year as stated above. Can I make this report
Create a query to use as the source for your report.
In query design, type this into the Field row:
FinYear: DateAdd("m", -6, [InvoiceDate])
replacing InvoiceDate with the name of your date field.
This yields 2007 for all dates in the 2007/2008 financial year...Date Formatting when Concantenating
I have a simple question. I have a cell that has date that looks lik
When I use the concantenate feature my date looks like this:
I tried to format the call every which way - but I cannot get it t
look the original.
Feeling really silly for even asking.. thanks all for your help
Message posted from http://www.ExcelForum.com
="Today is "&TEXT(TODAY(),"mm/dd/yyyy hh:mm")
Norman Harker MVP (Excel)
"bleu808 >" <<bleu808.189yij...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...Show a date 30 days out
I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].
Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later 31
I did =[Sold date]+30 and it did not work
how about dateadd:
dateadd("d", 30, [Sold Date])
"KAnoe" <KAnoe@discussions.microsoft.com> wrote in message
>I have a feild that I would like to show what the date would be in 30 days
> for a feild with a date in it [Sold Date].
...Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From cell 2D). The expire date in "2D" is either the word "none" or a date
that that persons license needs to be renewed.
Those instructors with "None" come out in the calculated field fine, however
the ones with dates come back as whole numbers, Example 8/6/10 shows 40396.
any help will be appreciated
You need to change the format of that cell or column, highlight the cell or
the column, right click o...Upgrading
I want to upgrade from Microsoft Money Financial Suite OEM Edition Version
11.0 to latest version but on trying to open the money file in Microsoft
Money 2007 I get the following error message:
File was created by an incompatible version
Question 1: As the old version was pre-loaded into the Computer when I
bought it in India, I don't know which country US/Canada/UK/Australia this
software belongs to. So how can I confirm which country is it for?
Question 2: And, how can I upgrade it to a version of Money from US or UK.
...Update MSN Services with Money 2007
How can I update the Portfoglio and Accounts on MSN with MS Money 2007
Deluxe version ???
Thank you. Bye.
In microsoft.public.money, Paolo B. wrote:
>How can I update the Portfoglio and Accounts on MSN with MS Money 2007
>Deluxe version ???
Transactions that you enter yourself into Microsoft Money 2007 would
not be forwarded out to MSN Money. This keeps that info on your own
For institutions with their own OFX servers, you would have to set
up those accounts to download into MSN Money also.
Accounts where the data comes in via "third party" ...Line Chart with dates in 5 day working week only
Trying to format a chart so that only the 5 working days of the week are
displayed on the x axis. The source data only has the five days (e.g.
05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005
etc etc) So I have missed out the weekend dates.
When I create the line chart however, the weekend dates appear automatically
and just show no point on the chart, therefore there is a longer line between
Fridays and Mondays!!
Hope this makes sense.
Does anyone have any ideas on how to change this? I have tried looking at
Tools-options-chart and cannot seem to turn...Money 2005 Crash and Unusable Myisam05.dll
My Money Deluxe 2005 cannot open my file, nor can it open any of the 3
backups. The crash references "Myisam05.dll." I read the KB and the one
post I found here, but I do not use investment toolbox. I cannot get to MS
support, because I cannot even open Money for more than a few seconds before
it crashes. I did try the Money 2006 Trial and it was able to open the file
without an issue. However, I cannot figure out why 2005 no longer works.
One other observationis that the current files have balooned in size, whereas
the old, outdated backups and new 2006 backup are simil...Error 1606 Money Service Pack 2002
I have tried all of the suggested fixes that I've seen on these boards for
the error 1606. I now have no money program, I can not reinstall the money
program and the error still pops up in my Turbo Tax and it is driving me
crazy! I can not delete the service pack from the add or remove programs
applet. I would very much like to finish the taxes before the 15Th. Does
someone know what is going on? I've deleted registry keys, done clean boots,
tried to eliminate every vestige of the program that can be found yet, when I
try to reinstall from the disk, I'm stymied by Error...Backup Money 2007 to DVD
I can backup Money 2007 H&B via CD using C:\Documents and
Settings\Chris\Local Settings\Application Data\Microsoft\CD Burning\MY Money
Backup but I want to backup with DVD. How do I do this??????
When exited from Money, use your favorite burning software and burn a DVD
from the file?
"Chris109" <Chris109@discussions.microsoft.com> wrote in message
>I can backup Money 2007 H&B via CD using C:\Documents and
> Settings\Chris\Local Settings\Application Data\Microsoft\CD Burning\MY
> Backup...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...Converting Money 2000 Canadian to Money 2006 Canadian
Can anyone confirm that such a conversion is possible? I was hoping to
convert to Money 2007 but was unsuccessful. I'll live with Money 2006
Canadian but I want to ensure the conversion is possible first. I don't want
to drop the money on it to find out it doesn't work.
Thanks in advance,
In microsoft.public.money, smurfgun wrote:
>Can anyone confirm that such a conversion is possible? I was hoping to
>convert to Money 2007 but was unsuccessful. I'll live with Money 2006
>Canadian but I want to ensure the conversion is possible first. I don'...Can't open Money 2002
Been using Money 2002 for 2 years no problem until now.
When I tried to open it, a window popped up (maybe showing
a registry or something) for about 1 second, then...
nothing. I even did a reinstall and at the end of the
installation when Money is supposed to open, the same
weird window popped up and then again... nothing. I have
Norton antivirus with automatic updates. All other
programs seem to be working fine. Any suggestions from all
you experts out there? Thanks.
In microsoft.public.money, Byron wrote:
>Been using Money 2002 for 2 years no problem until now.
>When ...date/time formatting
I download a csv report from a web based program. Everything works great
but the date comes through as "Jul 21 2009 1:51pm". I do not need the time
in my report. I have tried reformatting the cells, tried to copy to a new
file with the cells already formatted to "7/21/09", opening the cell format
using the F2 key and deleting the time (time will still not be formatted
correctly). The only way I get get just the time is to retype every cell.
What am I doing wrong?
I am using Excel 2002 SP3
When data is downloaded from the web, a lot of "other&quo...Problem with charting Net income vs Year
Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???
Use an "XY (Scatter)" chart, instead of a "Line" chart.
> Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???
Delete the co...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...ebay - ereseller stook my money
a terrible thing happenned to me on ebay.
i am a disabled woman in and eresellers took my money and never sent my washer.
his email address is email@example.com.
anything that you can do to help would be nice. ebay is doing nothing.
i can give a reward
This group is for discussing the Microsoft Money computer program.
Does it really sound like an eBay buyer complaint forum?
Do a google search on ebay and you will find a couple of groups, one
of which may reply to your problem.
That ebay seller has been selling on ebay for over 5 years.
On 1 Jun 2004 13:50:08 -0700, (An...Cannot install Money Plus
I have Money 2002 and uninstalled it. Wanted to upgrade to a new version of
Money. Tried to install Money Plus Deluxe (trial version) and keep getting
error Setup was unable to install some of the components needed to run
Money. Try installing Money again. Its HP M9300t Vista Home Premium system. I
tried the software on my XP computer and it work fine. So there must be a
problem with Vista. Any help would be appreciated.
I am having the same problem, but mine is in XP. I need a resolution
quickly, because having had to uninstall Money 2003, I am now left without
any checkbook regist...Re: Money class and Fixed Decimal Class in C++
I am rewriting code that utilized Rogue Wave Money class and their fixed
double class. Where can a find code to use for this. I assume that there are
millions of applications written that have required rounding of numbers to
Thanks for your assistance
That's a pretty vague question. Lacking any specifications of the classes involved,
figuring out how to reimplement them is problematic.
I first learned how to do this in 1965. It is old technology. Just figure out where you
want the trucation and keep the value in those units, e.g., cents, millicents, etc. The...Webmail vs. POPmail?
I have two different companies that do business together, so email is very
The problem is, one of the companies email is blocked by the other companies
email. The messages get bounced with the following message:
The original message was received at Fri, 6 Aug 2004 15:41:38 -0400 from
----- The following addresses had permanent fatal errors -----
----- Transcript of session follows ----- <firstname.lastname@example.org>...
Deferred: Connection timed out with namecha...Calculating dates #3
Can anyone tell me what I should use (in the way of helper cells)
to take any date (mm/dd/yyyy) and turn it into that same month
and day for specific year? For instance, turn...
10/12/2009 into 10/12/2010
4/6/1998 into 4/6/2010
I'm trying to determine anniversary date based on start date and
do it starting in 2010.
Assuming your date is in A1.
Hope this helps.
On Jan 5, 5:35=A0pm, Jordon <jordon@REMOVE~THISmyrealbox.com> wrote:
> Can anyone tell me what I should use (in the way of helper cells)
> to tak...how do I format cells to change date and time to just date
I want to format a column that contains date and time and I want it to show
just the date and not the time. Going into format and clicking on the date
and changing doesnt work.
Probably the cells aren't really dates, but text. You can check with the
If they are text, formatting doesn't have any effect.
Microsoft MVP - Excel
"bondam" <email@example.com> wrote in message
>I want to format a column that contains date and time and I want it t...Money 2005 Password Issue
I have been using Money 2005 for about 8 months and suddenly I cannot sign in
using my usual hotmail.com passport. The error message is "the e-mail address
or password is incorrect". However, I can sign in using the same e-mail
address/password pair to hotmail and MSN Money in IE.
I've tried KB Q331123 but no luck.
1) I can get into my Money file in offline mode
2) I even tried to change passport password. The new password works in IE,
but not Money.
> I have been using Money 2005 for about 8 months and suddenly I cannot...Money 2003 wants to install again
I upgraded from Money 2000 to Money 2003 online. I wanted
to get rid of all the works files so I used the Works
2000 cleanup tool. Now, whenever ANY window opens, it's
preceded by Money 2003 wanting to install. And the
knowledge base give a link to the money store and it asks
for the product activation key. To add insult to injury,
I called on 8/2/04@ 5:00 PM ET and recording said they
were closed, even tho' the hours are until 10:00 PM>
Sheesh!!! What next? Any one have any suggestions to stop