Skip to content


select by transaction date

Dave asked 9 years ago
I am trying to select the transaction value if the based on the transaction type and if the transaction is within a date range so I am trying to create a calculated field. As an example, on the selection from the PM Paid Transaction History table in Dynamics GP, I need the transaction amount to equal the transaction amount if the selection is where doctype = 6 and posteddt > ‘1/1/2013’ and posteddt ‘1/1/2013’ and posteddt < '12/31/2013' and voided = 1 I keep getting an invalid syntax error with every different scenario I use but the SQL query returns correct information in SQL Management query.
Jared replied 9 years ago

Hi Dave,
Can you export you SmartList Builder setup and send it to me at


If you would like to submit an answer or comment, please sign in to the eOne portal.