I'm working on something where I need to select unstored calc fields via an executesql function.
When I select Columns where the result of the Calculation is Unstored and the return type is text or number, I have no issues whatsoever. But when the return type is date, I get an empty string.
So for example if the query should return:
1, Class B , 2012-12-01
2, Class A , 2012-12-02
1, Class B ,
2, Class A ,
Has anybody run into this issue?
What can be done to fix this?