select by transaction date
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.
Hi Dave,
Can you export you SmartList Builder setup and send it to me at jared.dux@eonesolutions.com
Thanks
Jared