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

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

    carlo.m

      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?