Special Characters being returned from Data Formula fields

MarkKeener

Hello - I am having an issue with the data being returned from "Date Formula" fields such as the Item table's "Lead Time" or "Reorder Cycle" fields.

If I have "16W" in the field, SQL returns "16" with a little box as shown in the image below.


I get the same sort of results in the "Payment Terms" table as well so I'm thinking that it's an issue with "Date Formula" fields. Any ideas on how to get around this?

THANKS!!
-Mark.

kine

viewtopic.php?t=4660

MarkKeener

Thanks!! I had searched on "special characters", "date formula", etc. but couldn't find anything.

kine

You are welcome... ;-)