Why do my MS Project 2007 dates revert to circa 1984 dates?
For some reason my project start and finish dates keep reverting to '1984'
based dates...e.g '1/2/1984'
Anyone know why this is happening? I've seen this behaviour in previous
versions of the product (like MSP 98) but thought this would have been
resolved in 2007.
To recreate this error.
1. Create a new task in MSP and do not specify a start and finish date
2. Attach a precedessor to the task
3. Click save
4. Delete the predecessor and voila! Dates revert to xx/xx/1984.
I've notice that this behaviour appears for some users and not others, ...Date last filled...
Hi all :-) Access 2007, Vista Ultimate SP2 32 bit
I have a data entry form for entering prescription information. In need =
to be able to enter the date that the existing prescription was last =
I am in need of a means to look up the name of the prescription selected =
in the combo box for that field, and display the date that prescription =
was last filled for the new entry before it is saved. I am not sure how =
best to have it look up the data in the table.=20
Field name in the table is LastFilled and is a Date/Time data type. The =
current ControlSource is the ...X Axis date
I have a chart with the dates of the month on the top row. the next two rows have figures that are totalled on the 4th row (two types of the same size product). The fifth and 6th row have data on different sizes product.
DATE 1 2 3 4 5 6 7...
2X8C 2 1 4 5 1
2X8S 1 6 4 1 3
TOT 3 7 8 6 4
2X6 1 1 1 1 1
2X4 2 2 2 2 2
I want the date to show on the X axis and the last 3 rows to be the plot area. I've tried hiding rows 2 and 3, but that didn't work. Any ideas?
Assuming your sample data ...Need help to identify if a specific date falls within a date range
Using Excel 97 on WINNT.
Column C contains a start date (for example 20/12/2004 ) and column
an end date (for example 31/12/2004) for about 3000 entries.
Is there a formula or function I can apply to identify if the dat
30/12/2004 falls within this range, please? I have looked at Chi
Pearson's and David McRitchie's sites but am unable to see anythin
which applies to this problem (or maybe I'm just thick ... hmmm ..
could be something in that).
Any assistance would be greatly appreciated.
Lee Jeffery :
----------------------------------------------...Calculating elapsed time
What is the best way to store a time value in a text file and then use that
data to determine the amount of time elapsed since a particular operation
was performed? I am also wondering if the following applies to my
It is not recommended that you add and subtract values from the SYSTEMTIME
structure to obtain relative times. Instead, you should
a.. Convert the SYSTEMTIME structure to a FILETIME structure.
b.. Copy the resulting FILETIME structure to a LARGE_INTEGER structure.
c.. Use normal 64-bit arithmetic on the LARGE_INTEGER value.
I am not referring to GetTickCo...Date and hourly time of use
I have the start date, start time and end time for procedures throughout each
day for 13 procedure rooms.
I need to come up with an average number of rooms that are being used for
every hour of the day for each week over a period of three months.
Knowing the start and end times I have the duration of each procedure in a
room. I can indicate the hour of the procedure starting but how to indicate
the additional hours as being in use is where I am stuck.
Ex. Start date is 12/5/07 start time is 2247 and duration is either 276
minutes or 4.6 hours. How would I indicate that the 2300 hour,...DATE.DIFF results in French
I am use the DATE.DIFF function to return the time elapsed between two dates
and the results come back in years, months, days. But not in English, the
"1 an 2 mois 3 jour". Is there any way to fix this?
Maybe you use a function from a Add-in ?
Try this one from Norman Harker with the dates in B5 and C5
You can add text yourself
=DATEDIF(B5,C5,"y") & " y " & DATEDIF(B5,C5,"ym") & " m " & DATEDIF(B5,C5,"md") & " d"
Regards Ron de Bruin
&...charts with date...
Had a question in training today...
I have a chart as a separate worksheet. When I print this
chart, I want to see the date it was printed ON THE CHART.
How do I put the system date (something like =today()...)
on the chart itself so that it updates to the current date
for printing, etc.?
preview the chart for printing
use SETUP | HEADER/FOOTER
use CUSTOM HEADER (or FOOTER)
option to include date is available.
>Had a question in training today...
>I have a chart as a separate worksheet. When I print
>chart, I want to see the date it w...Replacating successive dates a week at a time?
My work week starts on Tuesday. I would like to have my worksheet show
column A-1 row starting with the date 05/25/04, the A-2 cell immediately
below it 06/01/04 and so on. Can I replicate this with out having to type
the date for each successive Tuesday through the year?
Jerry (newbie to Excel)
Put this formula in A2 and copy it down as far as you need to:
Hope this helps!
In article <unNAalPREHA.3528@TK2MSFTNGP09.phx.gbl>, "JER" <jer@home>
> My work week starts on Tuesday. I would like to h...Great Plains and RMS
I've upgraded our RMS systems to service pack 3.
We now have the option of selecting the GP accounting option.
It looks like we have to download an add-on for Great Plains..
Is this true ?
The one out there only says for import to GP 7.5
We are currently running GP 8.0.
Will it work for this version?
Do I even need this add-on, now that you can select the GP accounting option?
KB 893330 discusses integration with GP 8.0, but the links are broken for
the download. If my memory is correct, there was talk about a 10/01/05
"Scot S" <ScotS@discussio...Count dates until complete or Cancel
(Excel 2003) Is there a way to calculate the days and then stop the counting
when you have entered a completion date and/or cancelled appears in the
I want the duration column to keep calculating the days until either a date
is enter into the "Completion Date" Column or the "Status" Column has
cancelled or completed in it.
Start Date Completion Date Status Duration
3/15/10 3/20/10 Cancelled 5
...What is this great plains?
The website is down and i want to install CRM but find everywhere links to
Is the essential, just an add-on......?
...Include 1-x columns in @Sum depending on date
I have 12 columns, one per month
The formula for the Total Column should include only the
columns to represent a year-to-date total. How would I do
Jan Feb Mar Apr May
1 1 1 1 1
In March the total would be 3, in April the total would be
...Outlook 2002 server time out
DC = NT 4.0 SBS with Exchange 5.5
Internet E-mail = Outside Host
Workstations = 3 Windows 2000
5 Windows 98
Machine at Question Windows XP Professional
Equipment list On XP Machine:
AMD XP 2000 CPU
2 x 256 DDR 2100
OS = XP Professional SP-1
Office XP Standard SP-1, SP-2
When opening outlook checking mail, everything is ok untill you have a file
with a 1 meg+ attachment, At that point the machine seems to stall and you
must hit cancel -> at that point you can hit send and receive again and you
will get all the same...Collection management Time Zone Setup
It appears that when you install the CM module, you have to manually update
the Collection info screen per customer for the time zone.
Anyone have an easier way?
I would think that seeing as this looks at RM tables, wouldn't it be
wonderful to have the system KNOW what time zone the customer is in based on
What happens to customers who have several hundred or thousands of
customers? Am I missing something?
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I...plain text #6
Does some one now if there is an option in Outlook XP to read messages by
default in plain text? In Outlook express there is such an option but I can
not find it in Microsoft Outlook.
There is an add-in that allows this -
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Jacob asked:
| Does some one now if th...How do I calculate the # of business days between two dates?
I know absolutely nothing about coding. Trying to use calculations in a
report or query to accomplish this. Everything else I have found seems to
include "coding" that goes way beyond my capabilities. Anything a novice can
You need to use code:
You can call this function in a query
1. make the function a Public Function
In the query have a column like this
where [StartDate] and [EndDate] are actual fields in your query.
Everyone starts out a "Novice" but the m...great
This is a great newsgroup glad I found it.
hope to learn a lot here and natrally also to contribute.
There are more things in heven and earth tan we know
MAF Anti-Spam ID: 20070608110655W6g5FqZ2
---- Posted via Pronews.com - Premium Corporate Usenet News Provider ----
http://www.pronews.com offers corporate packages that have access to 100,000+ newsgroups
...It takes SO LONG TIME to open a query in design mode
Why does it take SO LONG TIME to open a query in design mode?
I can understand that it takes a long time to run a query that returns
millions of records.
But why won't it quickly open in design mode?
(MS Access 2003 on Windows XP)
What type of query? All queries or just some queries or just one specific query?
Where is the data physically located? On your computer? On a network server?
If you are talking about a query that is using a crosstab query as a source
then Access has to figure out what fields are generated by the crosstab before
it can open the query usin...Back Dating (Counting Backwards)
I was trying to use the following formula to come up with a date 40 work days
prior to the date specified in cell AN2. The following formula works great
except I work 4X10's (Mon - Thur) and this formaula is counting Friday.
Is there a variation of this formula that will do the same thing except just
count Mon thru Fri?
Or is there a better formula that will take care of my problem?
Simplest would be to add every Friday to your list of holidays....
MS Excel MVP
My brain is in drain mode today, so I am asking for your expert help.
Spreadsheet : Column F contains dates in each row - dates vary from any date
in 2009 to any date in 2011.
Column U ~ BO Header row contains dates to the first of each month ( U =
09/11, W = 09/12, X = 1/10 ) formated to show m/y.
I have played with the IF - statement, but I'm not getting what I need.
I would like to have the cell under each m/y to place that date in, IF it
falls within that month/year... or IF it falls between the m/y of the column
to the left and the column to the right - ...Great Plains
I have a report made in Crystal for purchase orders. I want to open this
report when I click on print button from "Purchase Order Entry" window.
Any help is welcome.
The easiest thing would be to purchase one of the third-party modules that
are available. One tool is from Accountable Software called Forms Printer.
Another tool is Crystallizer. I cannot remember who makes it, though.
Charles Allen, MVP
"Radu LP" wrote:
> I have a report made in Crystal for purchase orders. I want to open this
> report when I click on print butto...Date and time in a backup file name
I have the small T-SQL script below to backup my databases:
Here is a snippet:
BACKUP DATABASE [model] TO DISK =
WITH NOFORMAT, NOINIT, NAME = N'model_backup_2010_07_05_212931', SKIP,
REWIND, NOUNLOAD, STATS = 10
how to get timestamp automatically generated on execution ?
Thanks in advance
> how to get timestamp automatically generated on execution ?
You can build the desired filename in a variable for use in the BACKUP
DECLARE @Bac...Implemeting Portals in Great Plains?
What are the requierments to implement Portals for Great Plains for other
branchs to be able to access it online through the internet? Does Microsoft
provide a While Papers for Portals Deployements Guide ?
There are a few white papers concerning Business Portal, a Sharepoint-based
portal. You may want to log into CustomerSource and review them.
"MS GPS" <firstname.lastname@example.org> wrote in message
> Hi All,
> What are the requierments to implement Portals for Great Plains for other
> br...Faxing via desktop from Great Plains (customer invoices,etc.)
We have the need to fax from our desktops. We are on Great Plains 8.0.
Examples are customer invoices.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.