Hello,

 I'm trying to write a query to obtain the following information, and I'm having difficulty finding date columns to perform datediffs on. I'm trying to obtain the following info:

1.         A report of any asset where the Asset State changed from Not Yet Deployed to In use.  This would be for the past month.  Fields: CI Name,Model, CI Type, Barcode, Asset State, User

2.        A report of any asset where the asset state changed from any value to Disposed.  This would be for the past month. Fields: CI Name,Model, CI Type, Barcode, Asset State, User

If anyone could kindly help with this I would greatly appreciate it, I'm struggling badly and reviewing the table schemas hasn't helped me much. Thanks in advance!