7 Replies Latest reply on Apr 20, 2007 9:46 AM by pblecha

    Data format conversion issue

      I have a problem with data being corrupted in transit from a form to a query to output. Here is the statement:

      QuerySetCell(PartsOrdered, "Part",evaluate('form.partno#Counter#'));

      However, what is happening is, when a part number gets passed in that looks like 110-25-5 (which is, BTW, rather typical), it is being converted to a datetime object.

      I googled the issue of the Evaluate() method, and I'm aware it's a problem. However, I've tried a few different configurations to maintain the data format, and none work.