David Ball
Registered User.
- Local time
- Tomorrow, 08:36
- Joined
- Aug 9, 2010
- Messages
- 230
Hi,
I am importing dates from Primavera P6, via Excel, and any dates for activities that are already complete are in the format, 06-Jun-15 A, the “A” showing that the date is an “actual”.
I had been changing the dates to text as they were just displayed, but now I need to do some calcs with them (eg. 15-Jun-15 + 14).
I don’t really want the extra step of removing the “A’s” in Excel before importing to Access.
I set up a query that removes the “A’s” and was wondering if there is a way to then change the format from Text to Date in the query? I have tried the “Format” row in the Property Sheet but had no luck.
Thanks very much
Dave
I am importing dates from Primavera P6, via Excel, and any dates for activities that are already complete are in the format, 06-Jun-15 A, the “A” showing that the date is an “actual”.
I had been changing the dates to text as they were just displayed, but now I need to do some calcs with them (eg. 15-Jun-15 + 14).
I don’t really want the extra step of removing the “A’s” in Excel before importing to Access.
I set up a query that removes the “A’s” and was wondering if there is a way to then change the format from Text to Date in the query? I have tried the “Format” row in the Property Sheet but had no luck.
Thanks very much
Dave
