Oracle Primavera - PM6 Member for 19 years 8 months Member for 19 years 8 months Submitted by Barrie Callender on Thu, 2009-04-09 12:54 Permalink RE: Export to Excel Without Time You could always just change the display format of the columns with Date and Time in them. Member for 20 years 6 months Member for 20 years 6 months Submitted by Sherif Fam on Thu, 2009-04-09 11:51 Permalink RE: Export to Excel Without Time Hi, I encountered the same situation before. The fastest walk-around is to modify it in Excel. - Insert a new column in Excel (lets say C); just after the dates and times column (lets say B). - Make the new column as a formula "C1=Left(B1,10)" This operation will cut the unwanted time info; and you will e left with dates only. Regards, Sherif Log in or register to post comments
Member for 19 years 8 months Member for 19 years 8 months Submitted by Barrie Callender on Thu, 2009-04-09 12:54 Permalink RE: Export to Excel Without Time You could always just change the display format of the columns with Date and Time in them.
Member for 20 years 6 months Member for 20 years 6 months Submitted by Sherif Fam on Thu, 2009-04-09 11:51 Permalink RE: Export to Excel Without Time Hi, I encountered the same situation before. The fastest walk-around is to modify it in Excel. - Insert a new column in Excel (lets say C); just after the dates and times column (lets say B). - Make the new column as a formula "C1=Left(B1,10)" This operation will cut the unwanted time info; and you will e left with dates only. Regards, Sherif
Member for
19 years 8 monthsRE: Export to Excel Without Time
You could always just change the display format of the columns with Date and Time in them.
Member for
20 years 6 monthsRE: Export to Excel Without Time
Hi,
I encountered the same situation before. The fastest walk-around is to modify it in Excel.
- Insert a new column in Excel (lets say C); just after the dates and times column (lets say B).
- Make the new column as a formula "C1=Left(B1,10)"
This operation will cut the unwanted time info; and you will e left with dates only.
Regards,
Sherif