Hi there
I am wanting to pull out the transaction table data based on user defined inputs for the "TimeCreated" field.
I am familiar with MS Query and Excel in terms of how to set up the query so that the user can change the values to get fresh data, but I don't know how to limit the records returned based on the TimeCreated field.
Is this possible, and if so, what syntax should I be using? Below is my query without the date parameter.
SELECT Transaction.EntityRefFullName, Transaction.EntityRefListID, Transaction.TimeCreated, Transaction.TxnID, Transaction.TxnType, Entity.Type FROM Entity Entity, Transaction Transaction WHERE Transaction.EntityRefListID = Entity.ListID Group by Transaction.EntityRefFullName, Transaction.EntityRefListID, Transaction.TimeCreated, Transaction.TxnID, Transaction.TxnType, Entity.Type
Thanks Aaron |