I am running a query from a table that limits the output of data to a
specific time frame. I am working on the last month minus 12 months. So
what I want to see is from April of this year to May of last year. This is
progressive as the months change. i have been using:
Between (DateAdd("m",-1,Date())) And (DateAdd("m",-12,Date()))
This gives me this years May which I do not want.
Any help would be appreciated
Message posted via http://www.accessmonster.com
On Wed, 09 May 2007 19:18:04 GMT, "rollover99 via AccessMonster.com"
...error LNK2001: unresolved external symbol "long __cdecl _com_dispatch_method(struct IDispatch *,long,unsigned short,unsigned short,void *,wchar_t const *,...)" (?_com_dispatch_method@@YAJPAUIDispatch@
I have installed Visual Studio Express 2005, and the platform SDK.
I'm trying to compile, but get this linker error.
The only reference I found on the web was a post of this person describing
the possible cause:
Any clues, hints.. ?
Well, since you didn't bother to put the error message in the body of the text, it is a
bit hard to read. Please do not put content in the headers. I only see the first segment
of the header in my reader. A header that contains interesting informatio...Orders that have multiple release dates
I don't know of any other way to do this, but I am looking for
suggestions. Many times, our customers order parts, but want only so
much one month, so much the next, etc. In Great Plains, all of our
orders are entered in as back orders, and for each release of parts to
the customer, that is entered in as a separate back order.
I have read here on the newsgroup that each line item can have its own
require date, but then what? I have set that up in a testing company
here. I entered in some back orders with the same parts on it, but
with different require dates.
Is there a report that w...Date/ Phone log
I needed to create a spreadsheet for a phone log for my company. What it
needs to do is when a long distance call is entered in, well say column B.
Then the date and time the call was made needs to appear in column A. I've
tried several different approaches but none work.
Thanks for your help,
Take a look at
BTW - saying you've tried several different approaches but none work
isn't particularly helpful - *what* methods did you try, and what didn't
In article <AE61899F-B6C1-4BE0-9239-AA6B7602245F@micro...Conditional Date Format.
I would like to conditionally format a date. I have read earlier posts on
conditionally formatting numbers but I have been unable to transfer this to
dates. Here is what I want and maybe someone out there has done this.
If the date is before some cutoff point say 1970, I want the format to be
blank, otherwise format the date in RED as m/d/yyyy.
Is this doable?
You can't blank out the value within the cell using format|conditional
But you could use format|conditional formatting to make the cell look
empty--white fill on a white background.
Select the ...Milo: What is microsoft.windowslive.translator.btn? Name too long
In "C:\Documents and Settings\[myname]\Application Data\Microsoft\Windows
Live\Toolbar\Custom Buttons", there is a folder called
microsoft.windowslive.translator.btn that is causing me to have trouble
backing up my computer. I'm being told that that path or folder name is too
At first I thought it was the path, but trying to copy
microsoft.windowslive.translator.btn DIRECTLY into the MyDocuments folder
caused the same error, so now I'm pretty sure that it’s the 36 characters in
that folder name that is the problem. Sure enough, when I renamed a copy...Keyboard shortcut for current date and time
Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me
Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.
Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?
Thanks in advance.
CTRL+; then SPACE then CTRL+SHIFT+;
Portland, Oregon USA
wrote in message
Ctrl+ ; inserts current dat...Formating cells with date format
I have a worksheet with two columns. The first with date and the other with
text formated cells.
When I enter in the first one data with the year < 1900 the format never
assumes the right date format
Can anyone provide me with some explanation about this?
"Alexandre Duarte" <AlexandreDuarte@discussions.microsoft.com> wrote in
> Hi everyone.
> I have a worksheet with two columns. The first with date and the other
> wi...date confusion
hi im new to excel 2007
i want to ask that when i type 7/4 in a cell excel thinks that the slash is
division operator so it divides it ??
but in different cell it interpret it as date
ok another problem is that when I enter 7/4 in the different cell excel
interpret it as 4-Jul only but How do I display the year too ? even if i type
7/4/2008 or 7/4/08 it still shows 4-JUL ?
thank you very much
Format the cell as m/d/yyyy, you created the d-mmm format by just entering
7/4 so you need to reformat the cell to the date format you want. Always
use the full date when entering dat...Long Filename Hunter
is the anyone know of a
can search the disk for
files with "long" file names?
it is laborious to drill down
dozens of folders and
subfolders hunting down
down long file names.
for example I found a
couple of tiles with filenames
as long as a sentence,
obviously using all the
amount allotted for
naming a file.
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Veteran of the Armed Forces
- Microsoft Partner...Changing Publication Date and Pg. Nos.
I've created a newsletter using a Publisher template. At the top of each
page, the template automatically inserts the volume and issue number on one
side and the page number on the other side.
I want to have the volume and issue number at the left and the date at the
right on the first page.
On the inside pages, I want the page number, newsletter name, and date to be
at the top of each page, with the publication name centered and the page
number and date alternating positions (because the newsletter will be printed
front and back).
I've had no success trying to find the wa...Long Long Long Nested If Function
I need some help on a very long nested if formula. Or at least thats the
type that I have been trying to use to get the calculations on my
I have this formula which is working for me but it is only one of the 5
variables I need to include in it.
to this formula I need to add
=IF(B5="trto",IF(P...PLEASE HELP! need conditional formatting related to date, blank cells and today's date
I want to create a conditional formmatting formula that will highlight
a cell if that cell is blank and another cell that has a date in it
is more than 30 days from today's date.
So, if J2 has a date in it and that date is greater than or equal to
30 days past today's date AND K2 is blank, I want to highlight K2 red.
If K3 is not blank I dont want it to be highlightd.
can anyone help me with the correct formula/conditional formatting?
Thanks so much!
Try this in the Formula box of the CF dialogue:
If J2 is in the past (not clear from...Date question 01-14-10
Can anyone help with this function:
=IF[Date Parts Ordered Completed]+ [Date Part Completed]+[Date Purchasing
The goal is that is all three fields have a date in them, then put in today's
date in the final field. If one of the dates is missing, then the final date
is blank. The only problem is if I open up that form I do not want it to
change the date to today. I want it to stay the date of the actual
Any help is greatly appreciated.
Message posted via http://www.accessmonster.com
Try this --
Completion_...Dates 01/1/02005 comes u ps as 0.011111111
When I format for dates in a column I get this bogus number. How can I fix it
so the column reads the date entries?????
Discounting the typo, maybe you have a Lotus 123 setting enabled.
Uncheck Transition Formula Entry
(I unchecked all those Lotus 123 settings.)
> When I format for dates in a column I get this bogus number. How can I fix it
> so the column reads the date entries?????
> Thank you
...Does Validation works for date ??
Does data validation works for date ??
For example : A1 contains today's date in it & if some one tries to put
yesterday's date in B1 it will not allow(we can put tomorrow's date).How
it would be possible ??
Little Master's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28227
View this thread: http://www.excelforum.com/showthread.php?threadid=480089
I just used data validation yesterday for a date. What exactly do you want
"Little Ma...Date Calculation 05-17-07
I have two date fields in the format of dd/mm/yyyy. I want to be able to do a
calculation where it calculates the difference between the two dates.
Therefore the output will display the number of days.
Thank you for your help
how does this work??
Thank you for your help
"KARL DEWEY" wrote:
> Use DateDiff function.
> KARL DEWEY
> Build a little - Test a little
> "Kirt84" wrote:
> > I have two date fields in the format of dd/mm/yyyy. I want to be able to do a
> > calculation where it calculates the difference ...check between 2 dates
Is it possible to have excel check a date range from something like a form?
for example: I have various data entries on a sheet, the first column has
dates (01/01/04) format.
I would like to be able to check something like: 01/01/04 to 05/01/04.
Thanks in advance
The third form is usually best as hard coding makes formulas less
The second form might be better if the DATE argument...Replace Cell Address in A Long Formula
From time to time, I need to do some change in some very long formula. For example:
=TRIM(IF(ISERROR(FIND(" ",B46,FIND(" ",B46,1)+2)),MID(B46,FIND(" ",B46,1)+1,LEN(B46)),MID(B46,FIND(" ",B46,FIND(" ",B46)+2),LEN(B46))))
I want to replace all the "B46" with "F18". Is there a easier way? Thanks.
One quick and dirty way is to Edit>Replace B46 with F18.
"plumstone" <email@example.com> skrev i meddelandet
> From...Inserting Holidays and special dates in Calendar
Is there any easy way to insert Holidays and special dates into a publisher
There is no easy way.... You can merge.
What database programs do you have?
Mary Sauer MSFT MVP
"bwarten" <firstname.lastname@example.org> wrote in message
> Is there any easy way to insert Holidays and special dates into a publisher
...Date changing to current date when doc reopened
When I draft a letter and save it and then reopen it later, the date always
changes to the current date, even when I do not use the auto insert date. i
erase the date and put it in manually but it still happens.
sounds like you used teh insert date feature of Word. This inserts a current
field, which will update every time opened. Try replacing the current date
field with teh Create date field. HTH
> When I draft a letter and save it and then reopen it later, the date always
> changes to the current date, even when I ...how long does outlook 2003 save sent items?
i just looked today and all of my sent items from the past 4 years are
GONE!!! i do not use archiving, and i have checked my old archive folder for
them, they are not there.
any help would be much appreciated
gatestoo <email@example.com> wrote:
> i just looked today and all of my sent items from the past 4 years are
Then you deleted them somehow or are hiding them with a view filter because
Outlook doesn't delete anything automatically, unless you've instructed it
to do so.
...Date in adjoining field
I am new at this. Any help would be appreciated!! I have a
spreadsheet with data in L2. When the data in L2 is changed, I would
like excel to automatically post today's date in K2. Thanks for your
For a possible solution see:
For everyone's benefit keep the discussion in the newsgroup.
"Unorganized" <firstname.lastname@example.org> wrote in message
> I am new at this. Any help would be appreciated!! I have a
> ...long, LONG anf LPARAM
A very Basic Question.Can anyone tell me whats exactly the
long, LONG and LPARAM in windows.If they all are same then
what was the need to having 3 different names.any idea..??
thanks and regards,
"sada" <email@example.com> wrote:
> A very Basic Question.Can anyone tell me whats exactly the
> long, LONG and LPARAM in windows.If they all are same then
>what was the need to having 3 different names.any idea..??
"long" is a primitive type in C++. Windo...Sum Range of Dates
Can you do the following?
I have a big long spreadsheet with a lot of different dates. Can I
find out the results of one particular date in one cell at the top of
For instance, how much profit was there on 10/6/10?
Or even still, how much profit was there TODAY. Even though today is
ongoing and not completed. In other words I can see how the day is
shaping up even though all haven't reported in.
Yes, I can.
Look for help on the SUMIF function. Or see my earlier post which
gives an example that should fit your needs.
On Sat, 09 Oct 2010 18:19:32 -0700, Jim...