Forum Discussion
Filter active records at a specific date
Hello! So the problem is: I have a classic dataset with datewarehouse historization; each record has a validFrom, validTo and an isActive flag. I want to see the records in a table, that was ac...
Hello Rayulshah!
I'm really appreciate your answer! It seems, it would be perfect solution, however FIRSTDATE and LASTDATE functions are not supported in Direct Query mode.
Is there any possible workaround for this kind of problem?
Thanks,
Matt
Anonymous,
Do you connect to SQL Server using Direct Query mode? Could you please post the error message?
Regards,
Lydia