Extract data from TARGIT server with InMemory should allow a dynamic time criteria

When you extract data from your TARGIT solution using the TARGIT Server connection, (see: When you extract data from your TARGIT solution using the TARGIT Server connection, you should be able to set a dynamic time criteria)  you can't do any kind of dynamic criteria (or other SQL manipulations).

That means that you have to extract data first - cast your dates in data as datetime - and THEN set up a dynamic time criteria like where [Date] > dateadd('y',-1,Getdate()).

In usecases, where you only need e.g. yesterdays data - this is a little frustrating - so you should be able to set this criteria right away in the initial extraction.