Calculated SQL text
I am trying to import some records to my current customer table based on the following Calcualted query, but I am not getting any resulting data. My query looks like this.
Basically, I want customers we did business with during the past year based on WHERE OE_Orders.InvoicePostedDate
this query works perfectly fine in my sql server, but not on filemaker... what am I doing wrong? is it soething with quotations? thanks!