I am trying to understand the format of dates on the Table (Denormalized_Table1) attached, I copied the table to Microsoft Access for your revision.
I thought it was a Julian Date but is not. The Table information is from the Time Clock software called Amano Time Guardian, which was originally stored on a Firebird Server.
I need to prepare a report of puch in and punch out, with some special requirements but if I am not able to convert those dates to regular dates I wont be able to work.
Date fields are: DENCALCDATE, DENCACTUALOUTPUNCH and several others.
Please, if someone recognizes this format and tell me how to convert it I will appreciate the help.
Thanks and Regards,