How to work with dates and reporting
We're using SDP 13001 with SQL Server. We are needing to create some query reports as the report wizard is a bit limited for our filtering needs. How do we work with the dates? They seems to be stored as BIG INT and I'm not quite sure how to convert those to actual dates. For example, I want to get all workorders where the CREATEDTIME is > current time - 7 days, but I'm not quite sure how to do with with the dates formatted in these large integer values. Thanks!
New to ADSelfService Plus?