Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

changing actual dates

5 replies [Last post]
Tue, 2010-04-06 06:37
Mai Tawfeq
User offline. Last seen 9 years 32 weeks ago. Offline
Joined: 4 Mar 2010
Posts: 96
Groups: Civil Engineering, Women in Planning & Scheduling (WiPS)
hi every boday:

i need to change the actual dates (start & finish) columns , i have export the data to exel sheet but it looks evey cell like this :’1/5/2008 5:00:00 PM i need to shifft forwared 6 months , any body can help.

regards
Top

Replies

Wed, 2010-04-07 09:02
#1
Mai Tawfeq
User offline. Last seen 9 years 32 weeks ago. Offline
Joined: 4 Mar 2010
Posts: 96
Groups: Civil Engineering, Women in Planning & Scheduling (WiPS)
thanks a lot louie & Rodel.

regards mai
Top
Tue, 2010-04-06 09:59
#2
Rodel Marasigan
User offline. Last seen 17 weeks 2 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Hi Mai,
Another way is highlight all columns with date that need to change on exported excel file then press ctrl+h (find & replace). Find what: enter ’ (hyphen), Replace: (let it blank) then click replace all. All text date will become date format. On the blank cell with the same row enter a formula = (old date) + (date equivalent to six month).
Or you can use global change.
Create a UDF with new Start Date and new Finish Date
Run global change Actual Start = new Start Date
Actual Finish = new Finish Date.
Top
Tue, 2010-04-06 07:27
#3
Louie Corbeta
User offline. Last seen 13 years 18 weeks ago. Offline
Joined: 29 Mar 2007
Posts: 8
Groups: None
Hi Mai,

In addition to Alex, if you have a long list of activities that you need to change the actual dates, you could utilize the Export/Import facility.

All the dates when exported to excel will display in text format. All you have to do is to convert these texts into numbers in order for you to make a formula so you can change it to your desired dates. You could do the following in Excel to convert the dates into numbers.

 Open your exported Excel file.
 Select any empty cell. Right-click and select Copy. This will copy the empty cell…
 Then, select ALL the dates. Right-click and select Paste Special.
 In the Paste Special dialog box, under Operation select Add. Click ok.

This will convert the dates into Excel sequential date format. But, don’t worry you can format these numbers into your preferred date format by Format Cell.

Regards,
Louie
Top
Tue, 2010-04-06 07:14
#4
Mai Tawfeq
User offline. Last seen 9 years 32 weeks ago. Offline
Joined: 4 Mar 2010
Posts: 96
Groups: Civil Engineering, Women in Planning & Scheduling (WiPS)
thanks alex for reply.

regards
Top
Tue, 2010-04-06 07:03
#5
Alex Dale
User offline. Last seen 13 years 34 weeks ago. Offline
Joined: 15 Jan 2010
Posts: 4
Groups: Civil Engineering
Hi mai,

is it not possible just to do this on the status tab with Primavera. If you need to cnage the dates, uncheck the Finished or started box next to the dates and then change them as you need?

Top