7 Replies Latest reply on Dec 8, 2012 7:04 AM by beverly

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


      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?