Skip to content
+1-888-319-3663

COMMUNITY FORUM

select by transaction date

Dave asked 8 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 8 years ago

Hi Dave,
Can you export you SmartList Builder setup and send it to me at jared.dux@eonesolutions.com

Thanks
Jared


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