AnsweredAssumed Answered

ExecuteSQL returns unstored number and text fields, NOT date fields?

Question asked by carlo.m on Dec 7, 2012
Latest reply on Dec 8, 2012 by beverly

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

....

I'm getting:

1, Class B ,

2, Class A ,

 

Has anybody run into this issue?

What can be done to fix this?

Outcomes