Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

text method for field values

Hi.

I'm trying to write macros which works with bookmarks and got this problem: I'm using API to export all selected fields values to .txt file. I'm using this method:

set bmm = ActiveDocument.GetBookmark("BM02") 'getting Bookmark object

set

flditems=bmm.Bookmark.FieldItems 'getting active fields for Bookmark

set

BMFldValues = flditems.Item(i).Values 'getting selected values for field "Item(i)" for example it's DATE field

txsStream.Write BMFldValues.Item(j).number 'and I'm writing one of actual selected values in the DATE field to the file



BUT... in this way instead of date I got something like '36519' in my file instead of 25.12.1999, which is normal reaction for .number method. So, I'm trying to use method txsStream.Write BMFldValues.Item(j).text ... and here I got nothing, just an empty string in my file and in debug expression window.

So, how can I get text representation of numerical fields in API???

Thanks for help.

2 Replies
martin59
Specialist II
Specialist II

Hi, have you looked to get date representation of numerical fields ?

Not applicable
Author

Hi, Martin. Thanks a lot for answer.

No, I didnt see any "get date representation", dont even know what it is.

Can you tell me what is it or at least where I can find some info about this "get date representation"?