Need help on comparison of dates in different format.
I have question pertaining comparison of dates in different format :-
20 April , 2004 [Cell A1]
20-4-04 [Cell A2]
I was using if not function. ie. if(A1=A2, True, False). The result
always shown as False.
Pls help as to how could I do correct way solving this problem.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
are both cells real date values or are they stored as 'Text'?.
Check both values with
th...Two Steps at Once...
I have a column of stock prices in column B with associated dates in column
Let's call it dates in A1:A100 and prices in B1:B100.
In cells A101:A200 I repeat the same dates
In cells B101:B200 I fill down the formula =B2/B1 so those cells show the
daily change in the stock prices.
I can now calculate the STDEV of those daily price changes =STDEV(B101:B200)
How can I do this in one step, direct from a column of stock prices to the
STDEV of the daily price changes?
which is an array formula, it should be committed with Ctrl-Shift-Enter, n...Reminder Date in Outlook 2007
I would appreciate help with this problem. I often set reminders on e-
mails using the Right click on the e-mail in my inbox and selecting
Add Reminder... My problem is that the default date for the reminder
is:01 January 4501 at 08:30 am. I am perfectly happy with the time,
but cannot find where to change the default date for this option. My
computer date and time are correct, and so is my calendar in Outlook
working on the correct date. I am running Windows XP Home SP3 and
Office 2007 SP1.
...Need Help with Sumif Function including dates
I need some assistance with tracking my commissions that are due to be paid
each month. The "Comm Due Date" is in column "C", rows 3 - 30 which list by
date all of the Commissions Due to be paid and the "Comm Balance" is in
column "H", rows 3 - 30 which has the Commission Balance due for each sale.
I tried utilizing a formula from a post that I found from April '05 but for
some reason I keep receiving a #NAME? error. I'm not sure what I am doing
wrong. I want to find the total due by month so that as I add additional
sale...Excel Web Queries
I know how to setup Excel 2002 web queries from sites that are publicl
available. The question is: *can you setup web queries linked to a we
site that is private (i.e. you need a password to access it) such a
your private portfolio in Morningstar or similar sites?
rpensotti's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1464
View this thread: http://www.excelforum.com/showthread.php?threadid=26267
...Pivot table question #9
I recently had a problem with values not showing properly in my PivotTable,
until it was poited out to me that I was using Text in some cells instead of
Ideally, I would like to include text. Is there anyway at all that I can?
My data comes from an Access Table by the way
the data in the pivot shows scores overall of several years competition, and
each meet has 2 reserves, who can step in for an excluded competitor.
However, the reserves might not compete, but still need to be recorded as a
competitor at the event.
Rather than showing zero (0) as their score, I'd r...Priv1.edb has old date?
I was checking the size of my Priv1.edb files today on my two exchange
servers and noticed the date windows explorer is reporting is two days old
(9/15/04). Is this normal? Both servers are up and running with many users
and no trouble reported.
Note that size of the edb file may not be accurate either while the
store is up. If you stop the IS , it should give the accurate size on
On Fri, 17 Sep 2004 16:51:09 GMT, "You Know Who"
>I was checking the size of my Priv1.edb files today on my two exchange
>...two types of opportunities, cloning?
we would like to use two different types of opportunities in CRM 3.0.
One would be for standard products, and one for service. We've been
thinking about it and having separate entity for service opps seems
just to be the way for us. Easier when adding data, much more
convenient to display...
So, is there a way of cloning the opportunity entity in a way that we
could use its functionality for another entity? Just like deriving a
class in OOP. Or any workaround like creating a new entity and linking
an opportunity? Or the other way round? Any thoughts on this are
...two copies of every email in crm3
Whenever a user sends an email message from within a crm3 account as an
activity, two instances of the original message subsequently appear in
"history." how do i ensure that only 1 instance of an email is kept?
many thanks in advance
This does happens if you sent an email from one Crm user to another. If this
is the case you can avoid this by going to Settings > Organization Settings >
System Settings and on the tab E-mail Tracking set the second radio button
(Exclude e-mail) to Yes.
If it is not user to user mail the above won't change that.
Patrick Verbe...Difference between yyy and yyyy?
When typing custom formats, yyy appears to do the same thing as yyyy.
Some online tutorials seem to indicate this is a hold-over.
Does yyy have any official function?
Ck5vLCBpdCdzIGp1c3QgZmFpbC1zYWZlIGFuYWxvZyBmb3...How to pick date and month?
Hi All -
Could you please help me on this?
In a worksheet "A" column containing birthdays(date, dd/mm/yyyy). How
can I write a code to show date & month("A" column) matching with
todays date & month in the respective "B" column.?
Thanks a lot in advance for your helps...
You don't really need any code for this, a simple formula will work as I
understand your question. Try this: =IF(A1=TODAY(),A1,"")
Enter this into cell B1 and copy it down the rows that you need it. It will
display the date in th...Problem starting different http connections from the same application
I have a multithreaded application in which one thread sends a request
to a web server -and reads the response for a while (which is why its a
separate thread). The other thread needs to send data periodically to
the server - but this is where I run into problems. In the method that
the second thread uses makes a new session , gets a new connection,
creates a new http file - but fails to send the data.
Looking at the ethereal captures, it seems that the second thread is
sending requests through the same tcp connection that the very first
request (that hasn't returned yet) we...won't recognize two different cd's
I am trying to rip two differentcd's, the media player insists they are the
same and copies one over the other. What do I do?
> I am trying to rip two differentcd's, the media player insists they are the
> same and copies one over the other. What do I do?
If you purchased the CDs or have them on their originally produced discs,
you shouldn't have a problem. If they were burned to CD from another device,
try changing the 'quality' settings under the rip menu to the highest
setting. They might be on low quality CD's that ...Please Help: compare values in two columns present in seperate tab
How can I compare values in two columns (columns are in different tables) ?
I also want to display the values that dont match in a seperate table.
If values in Column1 from Table1 does not match Values in Column1 from
Table2 then display those values in a seperate table
Is there a way to do this?
THanks in advance
Here's one way:
If this information was helpful, please indicate this by clicking ''Yes''.
"sam" wr...To Query or not to Query??
Hello all -
I'm a newbe to Access but have made great progress. I'm using Acess 2003. The
db is up and running prefectly. Now I need to tackle the reporting. I have
seen posts about reports and queries and am a little confused. Do I need to
create a query to run my reports off of? I have a tabbed subform in the main
form. There are seven tabs breaking up all the services we provide. Like
"Promo Items", "Leads", "Client Printed Material","Internal Print Material"
and so on. The main form has the User, Branch and Marketing Rep.
I need to...Append query?
Hello Experts,I have an Append query that takes data from one table and puts it intoanother.I only want the query to insert rows, however, where two records aredistinct.I've tried using the QBE and writing some SQL code.Something like this:Insert into Table_ASelect Table_B.*>From Table_BWhereTable_A.cust_no <> Table_B.cust_noAndTable_A.empl_no <> Table_B.empl_noDoes anyone have any ideas?I'm basically trying to use an Append query to back up a table. Ionly want the query, however, to append new records.alex...Cleaner way to query for negatives?
Access 2000, Win XP SP2
I'm looking for a cleaner way to determine whether or not an entry in one
table has a specific field checked yes or no in another table.
fldVendorID (Primary key, no dupes)
fldVendorID (dupes allowed)
Table 2 can have many fldContacts per each fldVendorID from Table 1.
fldAllowed is a yes/no field.
I want to query for any VendorID which has NO fldAllowed=yes.
I've done it this way:
Query 1 counts all contacts from Table 2, grouped by fldVendorID
Query 2 counts all fldAllowed="No"...return all records in crosstab query
I have a combo box on user pick form where users can choose one Operator and
leave the box blank to return all records. How do I revise my below code to
allow users to leave the [frm_Pick_Operation_Emp_Chart]![Operationcmb] field
on my pick form blank? Thank you!
PARAMETERS [forms]![frm_Pick_Operation_Emp_Chart]![BegDatetxt] DateTime,
[forms]![frm_Pick_Operation_Emp_Chart]![Operationcmb] Text ( 255 );
TRANSFORM Sum(qry_Defect_by_Operation_Emp_Chart.[SumOfDef Qnty]) AS
SELECT qry_Defect_by_Operation_Emp_...Sort grouped unread email by date?
My unread email is grouped by folder. How can I get the mail in each folder
to sort by date?
I tried sorting by date, then folder, but the dates get scrambled after the
...Reestablishing Outlook Files from a Different Location
Just recovering from a crash with a new hard drive. Using XP with Outlook
2003 and need to change from the default path to c:\exchange for the location
of all Outlook Files, Mail Boxes, Address Book, Contacts, Folders, etc.
Managed to change path for Address Book, but not the rest. Not on network
Need to recover old e-mail, folders, etc. Any and all assistance gratefully
Les <Les@discussions.microsoft.com> wrote:
> Just recovering from a crash with a new hard drive. Using XP with
> Outlook 2003 and need to change from the default path to c:\excha...Two-Axes Pivot Table Chart
Hi Folks - Here's my dilemma ...I have a pivot table that looks like this:
Unit1 SumOfCatCount 50 60 70
CountOfCat 1 2
Unit 2 SumOfCatCount 55 60 70
CountOfCat 3 4
Unit3 SumOfCatCount 75 75 80
CountOfCat 2 5
I can make a nice...Size of file with pivot table
I have a file that was 8MB when I started. I created a pivot table pulling 7
fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot
table would cause the file to be so large when the 8MB file already had pivot
table sin it?
When it was 8MB, it had 6 pivot tables.
Now it's 20MB and it has 7 pitvot tables.
Why is this one table so much larger?
Were the 6 PivotTable independent, or did they all use the same cache?
If you build PivotTables that use another PivotTable as reference (for when
you're reference the same raw data, just taking a different...Store Sent Items in a different mailbox
I would like to create a general email box for one of my groups and what is
happening is that whenever there is a reply, the copy of the sent email is
put onto the individual email box and not in the general. Does any have a
solution to my problem where, if I hit reply on the general box a copy of
the sent will be place in the general sent folder as oppose to that one
particular email. TIA.
You can only configure a Wizard Rule to move a copy of the message to a
different folder so it will end up in both.
Microsoft Office and Microsoft Office related News
Also ...Converting dates to fiscal quarters
Is there a way to easily convert a date to a fiscal quarter
Eg 1/1/03 converted to Q1-2003, 12/7/98 to Q4-199
Thanks in advance for your respons
One way with the date in A1
="Q"&INT((MONTH(A1)+2)/3)&" - "&TEXT(YEAR(A1),"@")
"James" <firstname.lastname@example.org> wrote in message
> Is there a way to easily convert a date to a fiscal quarter?
> Eg 1/1/03 converted to Q1-2003, 12/7/98 to Q4-1998
> Thanks in advance for your res...When to split a single database into two
I'm creating a database in Office2003 Access. This is my first time doing
this. After reading a manual, I'm still trying to understand what constitutes
a need for separate but linked databases?
My proposed database is to track inventory, log and monitor trouble tickets,
users, and document service and pertinent information of network devices. I
could have one very large database with a lot of tables (how many is "a lot"
or too many?).
or... should I break these up into 2 or 3 databases (and link them)?
Just looking for loose advice here - maybe some good book title...