Daylight Savings Time Changes
Does anyone know if the patch for Exchnage 2003 identified in KB926666 has
to also be applied to every server that is running the Exchange Tools (System
Thanks in advance
On Wed, 31 Jan 2007 10:24:03 -0800, Kerry
>Does anyone know if the patch for Exchnage 2003 identified in KB926666 has
>to also be applied to every server that is running the Exchange Tools (System
>Thanks in advance
Im all for consistency. If the patch isnt needed, it shouldnt install,
so I would at ...How to sort a list correctly?
whenever I sort my list in excel it all gets messed up. What am I doing wrong?
Is there something I can do to stop this happening?
THanks in advance
try selecting the entire data range before sorting (Use 'Data - Sort'
"Melani" <Melani@discussions.microsoft.com> schrieb im Newsbeitrag
> whenever I sort my list in excel it all gets messed up. What am I
> Is there something I can do to stop this happening...Is there a way to Sort Data by font color or cell shading?
I have a long list of items that I sort by either item number or date
depending on what I'm looking for. From time to time these items status will
change and I will gray them out by just shading the background of the cell
Is there a way I can sort these items by the background/shading of the cell
first and then the secondary sort be date?
So all the cells which contain gray shading will be first in the list
(sorted by date if possible) then the rest of the list without the gray
shading will follow by date as well.
Take a look at this link:
http://www.cpearson.c...Date on Template
I created some templates and am choosing to bring over a date to be shown in
the template when it is run. I have selected this attribute to be date only
and not date & time.
Every time I run the template it still shows date+time+time zone. Is there
a way to show only the date and not the rest of the data.
Thanks for any help anyone can provide.
...Alpha sort names/numericals
I have 2 columns. 1st column has names, 2nd has numerical values relevant to
the names. How can this data be alpha sorted and keep the same name/numerical
"dane" <email@example.com> wrote in message
> I have 2 columns. 1st column has names, 2nd has numerical values relevant
> the names. How can this data be alpha sorted and keep the same
Please state clearly what the problem is.
If you sorted and got the names sorted and the numbers did not...Calculate Dates with If Then Else Statements
I need to calculate total years’ full time experience (i.e. 2.5 years, 3.25
years, etc.) in an Access 2003 database form. This is what I am trying to
do: If the Full-Time End Date is Blank, use Today's Date, ELSE if the
Full-Time End Date has a Date, use that Date.
Separately, these two formulas work:
My problem is writing a statement to calculate using the END DATE if one is
entered, or NOW, if there is no end date. I have tried many combinations,
but can’t ge...sort data
i am trying, unsuccessfullty, to sort some data (a small example is below) so
I can graph it. I want to put it into a pivot table format but don't want
calculations, just the actual data. any ideas??/
Location DATE Result
WAT002WA ALBANY BOTTOM 19-Jul-05 0.83
WAT002WA ALBANY BOTTOM 23-Jun-05 0.8
WAT002WA ALBANY BOTTOM 28-May-05 1.16
WAT002WA ALBANY BOTTOM 02-May-05 0.93
WAT002WA ALBANY BOTTOM 06-Apr-05 0.66
WAT002WA ALBANY BOTTOM 11-Mar-05 0.59
WAT002WA ALBANY BOTTOM 13-Feb-05 0.54
WAT002WA ALBANY BOTTOM 18-Jan-05 0.62
WAT002WA ALBANY TOP 09-Mar-07 0.73
...Outlook locks up all the time
This is a shot in the dark. Ever since getting my new
Thinkpad with Windows XP, Outlook has never seemed to work
properly. I've run diagnostics on my machine and nothing
comes up as a problem. I've installed a spyware program
because after talking to IBM tech support, they suggested
I try that. I also talked to another support tech, who
suggested I reinstall Windows completely. I'm not a real
technical person. Won't a re-install wipe out my files?
Most of the time that I use Outlook for my email, it slows
down and eventually locks up. When I restart my computer,...Running macros for different cells at the same time
Is it possible to run different macros on different cells at the sam
time? If so how do I go about setting it up?
Message posted from http://www.ExcelForum.com
not really sure what you're trying to do. Could you give an example?
> Hi all,
> Is it possible to run different macros on different cells at the same
> time? If so how do I go about setting it up?
> Message posted from http://www.ExcelForum.com/
Yes it is possible to run different m...Filter Date
Hi, I have a form which contains a listbox (holding the values Process
Date and Quantity) and I have a textbox which displayed the current
month. What I want to do is when I click on a command button
(cmdMonthDown) and the textbox value changes from May to April I want
the values in the listbox to be filtered so that only those values are
disiplayed that were entered in April.
If I'm not making sense please let me know otherwise your help would
Reference the text box as a parameter in the list box's RowSourcee, e.g. if
the text box shows the month name in fu...Task start/end dates from MS project to Workspace site
We are currently running MSPS 2007 with WSS 3.0. I am trying to create a list in one of the project work spaces. I would like to auto-populate two columns in that list with the start and end date of certain tasks from the Project Plan in MS project. I am thinking we can do this by linking these columns to the the project SQL database fields. So,
1) Do I use the published SQL databse for this?
2) Which fields in the SQL database would I have to link to get the Start and End dates?
EggHeadCafe - Software Developer Portal of Choice
AutoList in ASP.Net
http://www.eggheadcafe.com/tutorial...Date Format when incoming date can be 0
I have a date fiels yyyymmdd which can have a value of 0 or a valid date in
Excel displays the 0 date as 01/01/1900 and the non zero dates as expected.
Cant figure this out , any help would be appreciated.
Excel uses a sequencial number from either 1/1/1900, or 1/1/1904 (depending
on your options) as the date value
for Example 6/3/2005 is 38506 using the 1/1/1900
if the cell is formatted as a date it is responding with the date it thinks
If you want the cell to display a zero
"DP NY10601" wrote:
> I have a date fiels y...how to calculate the substraction between two dates
i have two cells ,in which there are two dates.
(for instance ,one cel l 08/02 ,the other 07/30)
if the gap of the two dates is 2 days , something will be set to do.
but it is difficult to judge the the substraction between two dates
any good ideas.
Perhaps this might be of help ..
Assume the *dates* "2-Aug-2004" and "30-Jul-2004"
are input in A1 and B1, and
A1:B1 is custom formatted as: mm/dd
viz. it'll show as:
In A1: 08/02
In B1: 07/30
Try in C1: =DAY(ABS(A1-B1))-1
Format C1 as: General or Number
C1 will return: 2
i.e. the number of days...Date Range
When I want the date rage appeared on the report header, I use textbox and put
(qry criteria) in its recordsource. It works fine.
However, For this time, I got a message like this ‘First([Between [From this
date] And [To this date]])"
Is there something wrong with the qry criteria?
Would you please show me how to fix the problem?
It's very hard to understand the crtieria, can you post the full SQL
What is the First in the beginning?
Why there are to square brackes in the end And in the beinning?
First([Between [From this date] And [To this date]])"
T...Sorting imported text
I have a spreadsheet into which I've imported a great deal of data in two
columns only. I set out rows one, three and five of hundreds of such rows.
The cells in column A consist of place names. (The "C" following the place
name stands for "City", the "A" for "Area".) The cells in column C represent
the population of the city or area, as the case may be. I've formatted the
cells in column C as numbers.
Albury (C) 44887
Armidale Dumaresq (A) 24596
Ashfield (A) 40258
I want to sort the placenames in order of their po...download the Credit Card transaction date not the the posting date
Then I download a statement from a Credit card and import it in to MS Money I
always get the Posting Date not the Transaction date.
Do I need another column in the register, help does not tell me how to do
Or is the only solution changing each entry by hand? ( that doesn't make
This credit card offers downloads in either QIF or spreadsheet.
In microsoft.public.money, riskymanr wrote:
>Then I download a statement from a Credit card and import it in to MS Money I
>always get the Posting Date not the Transaction date.
Do you mean you first enter the transactions by...How do I convert a time format to a double
I use a function to calculate the hours worked based on time
12:00pm to 4:00pm is 4.0 hours
when I get the number for hours worked it is in time format / .27398237 I
need the number 4 so that I can do my calculation. How do I convert it to a
Multiply with 24 and format as general
"DMB" <DMB@discussions.microsoft.com> wrote in message
> I use a function to calculate the hours worked based on time
> 12:00pm to 4:00pm is 4.0 hours
> when I get the number for hou...If Formula , Adding Days to a Date
I want to make a formula that calculate as following;
in Cell (B1) if the date in future the result will be [Enrolled], if not it
will be Cell (A1) + 730 Days
On Sat, 27 Mar 2010 02:14:01 -0700, Khalid A. Al-Otaibi
> A B
>I want to make a formula that calculate as following;
>in Cell (B1) if the date in future the result will be [Enrolled], if not it
>will be Cell (A1) + 730 Days
Try this formula in cell B1:
=IF(A1>TODAY(), "[En...lookup a date from an array of date ranges if conditions are met
Please help...i need to lookup up a value on a specific date range.
column A: column b
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Sounds like autofilter could be something, select the data (should have
headers), do data>filter>autofilter,
filter on the date column using custom and gate than or equal to and put
09/01/03 as a criteria
"nscanceran" <nscanceran.wj1qn@excelforum-no...Release Date of V 4.0
Does any one know the official release date for CRM V 4.0? Will CRM V 4.0 be
available for partners before it is available for the general public?
...looking to sort my personal address book
trying to find how I can sort my personal address book by
last name, comma, first name
Are you really using a Personal Address Book? Why?
It was replaced by the Outlook Address Book 6 years ago.
The PAB cannot be sorted by Last, First because both names are in the same
"Glen" <firstname.lastname@example.org> wrote in message
> trying to find how I can sort my personal address book by
> last name, comma, first name
Russ, all my contacts are in "my personal address book&qu...TIME function used in Excel
I'm new to these newsgroups, so I apologize if my etiquette is not
I'm trying to help a friend whose computer was recently replaced. In his
new computer, his custom macro will not run. He gets a "Microsoft Visutal
Basic Compile error: Can't find project or library" with the TIME function
I first suggested using the NOW or DATE function, but he said it creates an
additional series of errors.
I also tried installing 'Windows Script 5.6' to no avail. Any suggestions
on how to get this TIME function to work?
Thank you in advance for ...Sort data Excel 2007
How to sort using date and then time in an "a" and "p" format for Excel
A normal sort should to what you want. Nothing special here...
"Billy Bob" wrote:
> How to sort using date and then time in an "a" and "p" format for Excel
Bob, I entered the dates under "date" and the time under "time". The time
was entered as 10:00a - 2:00p - and 1:00p but it did not sort them. The date
came out correct but I added another level and the sort asked for A - Z. I
finaly went to military time and that worke...Date and Time formular
I'm trying to take one date and time away from another but having a problem
fathomining it out
01.04.2008 10:55:27 - 01.04.2008 9:37:13
The date and time are in the same cell eg 01.04.2008 10:55:27 is in A1
A formula for this would be great if anyone has one to hand
"SS" <Student.email@example.com> wrote in message
> I'm trying to take one date and time away from another but having a
> problem fathomining it out
I need to sort a column in desending order so the first number is 121, 120,
etc. down to 1. Some numbers have an alpha (68a, 68b) but I still want them
in the correct order. Right now the cell formating is "general." How do I
The answer you get is not likely to be better than your description.
So all I can say is see if this solves your question.
Create a helper column to extract the digits, and sort on that as
a descending number. Then sort on the original column which is
text in ascending or descending order depending on if
68a is to come before 68b ...