This is the problem that I am currently working on. Any help is appreciated!
The reason for the QOQ is to rename the columns to have proper name value pairs in the view.
I could get the value from the first query successfully by Q_ExcelObject.IID
Cast in the QOQ did not do the trick as mentioned here
But apparently when doing a QOQ the value is cast to a date time even before the value is set with cast in the new query. :(
I found a rename function by Steven Neiland hereNice work Steve! THANKS! :)
No comments:
Post a Comment