Skip to content

P3e Database Mapping

Emma SeatonMember for 21 years 1 month
Created
2
2
0
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

2 replies

Oldest first
  1. 0
    Niek Zonneveld ·
    Emma,

    last_recalc_date in the Project table.

    H.T.H.

    Niek.
  2. 0
    Emma Seaton ·
    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

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?