Hello,
I'm trying to change the date format in a query element to make it user friendly for WordFly and I can't seem to get it work. Looking at the documentation, I should be able to use the CONVERT function in the system table to do so, but I'm getting an error. Alternatively, I tried setting up a new view and did the conversion there and that seems to work, but I can't get the elements in the new view to pull into my output set. I've granted SELECT permissions to ImpUsers and Tessitura_App and WordFly in SSMS.
And also related -- even when I have the output set working (with the dates in the wrong format, but the data pulling in from another view), WordFly can't seem to find those fields -- can it not use custom output elements? They aren't showing up as fields to be mapped.
Anne
Anne,
What error do you get when you try to save the system table with the CONVERT function? Also, what format are you hoping to get output? (Put out?) (Out of your output?)
John A. Moskal II
It saves okay in the system table, but I get an error parsing the field when I try to view the results in list manager.
I wonder if it has to do with the datatype somehow. Like the output rendering is expecting a DATETIME but getting something else.