I am trying to determine the last time a project was opened in Comos.

In the SQL database,  I see the table 'dbo.LC_Project'. This stores the project UID, user UID and a field called login_date which contains a number (typically 12174, 12745)

A new record is added to this table each time a project is opened.

But, what does the date 12174 relate to. How do I get the actual date the project was opened ?

Can anyone help ?  Thanks

Good morning

try to use CDATE

'The CDate function converts a valid date and time expression to type Date, and returns the result.'

KR

I don't have a login_date in 'dbo.LC_Project' but see one in the 'dbo.LC_Projlog' table...

anyway... If the date is in Julian format, 12174 typically means the 12th year of the century plus 174 days. For example, if the base year is 2000, it would be 2012 plus 174 days. = 22 June 2012


Julian Date Conversion Charts (oracle.com)

hope this is what you want

COMOS uses its own data format on the sql server.

12174: 14-Apr-2020

12175: 15-Apr-2020

if you have a test data base, you can modify the timestamp date on the sql server via sql and check in COMOS which date it really is.

CDate does not work in this case, as CDate is used for data conversion between Microsoft data format. there is also no linear behaviour between Microsoft and COMOS date 

eg. 12174 (COMOS) = 43935 (Microsoft) = 14-Apr-2020