Exporting dates from MSP to Excel

[Janet BN]

Hi,

Is there anyway I can remove the time portion of the date fields when I
export to Excel. I need to do some calculations based upon the dates when
the get to Excel and having the time attached is messing it up.

i.e. date in MSP is 01/12/06 1:00pm but I need it to be just 01/12/06 when I
import to Excel.

Any help greatly appreciated.

Thanks.

 

[Rod Gill]

Excel handles this format fine. To remove the time, simply convert to a Long
then back to date again or convert the date portion of the date to a new
date in another cell and use that.

 

[Janet BN]

Thanks Rod, worked great.

Though, is there anyway to change it during export or on import. Lots of
pivot table reports are using the MSP data and I don't really want to add
columns to the source data (the export file) each time - if I can help it.

A bit lazy I spose'.

Cheers,

 

[Rod Gill]

You could add a formula to a Date column such as Date1. Formula would be:
DateSerial(year([Start]),month([Start]),day([Start]))

In Project there would always be a time of midnight, even if it's not
displayed. See how it gets exported to Excel.

 

[Janet BN]

Thanks Rod, will give it a try - Janet

You could add a formula to a Date column such as Date1. Formula would be:
DateSerial(year([Start]),month([Start]),day([Start]))

In Project there would always be a time of midnight, even if it's not
displayed. See how it gets exported to Excel.

--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more

Thanks Rod, worked great.

Though, is there anyway to change it during export or on import. Lots of
pivot table reports are using the MSP data and I don't really want to add
columns to the source data (the export file) each time - if I can help it.

A bit lazy I spose'.

Cheers,