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.

P3e Database Mapping

2 replies [Last post]
Wed, 2006-04-19 11:07
Emma Seaton
User offline. Last seen 10 years 48 weeks ago. Offline
Joined: 16 Sep 2005
Posts: 55
Groups: None
Does anyone know which database field maps to the data date. I can find just about everything else in the Schema Documentation tables, but no data date to be found anywhere, have I just missed it or is it not there? I need it for a query in excel where I’ve linked up a spreadsheet to the P3e MSSQL database.

Cheers

Emma
Top

Replies

Thu, 2006-04-20 04:03
#1
Emma Seaton
User offline. Last seen 10 years 48 weeks ago. Offline
Joined: 16 Sep 2005
Posts: 55
Groups: None
Thanks Niek, that’s brilliant - I knew it had to be somewhere, I just wasn’t expecting it to be called ’recalc’ - I’d been looking for ’data’ or ’schedule’ date... I am very happy now!! :o)

Cheers,

Emma
Top
Wed, 2006-04-19 13:29
#2
Niek Zonneveld
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 17 Mar 2005
Posts: 188
Groups: None
Emma,

last_recalc_date in the Project table.

H.T.H.

Niek.
Top