Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RQM 5.0 : RQMEXcelImporter : Date format issue

Questions
Tags
Users
Badges
Naveen Tyagi
(197●78●152) Mar 19 '15, 1:01 a.m.
 I have three custom sections in Excel file and all of them contain Date[dd-mm-yy] as value. i have imported successfully but instead of date a four digit no. getting mapped in RQM. how to sort this out ?
i have used this for creating and mapping custom section in RQM. "testplan.Section("myns:CustomDate1","CustomDate1")=E. Thanks in Advance.

0 votes

2 answers
3,728 views
0 votes

Accepted answer

Permanent link
William Chen
(312●1●5) Mar 19 '15, 2:56 p.m.
A quick fix would be to change the date format to text:

Naveen Tyagi selected this answer as the correct answer

0 votes

Comments
William Chen
Mar 19 '15, 2:58 p.m.

Naveen Tyagi
Mar 23 '15, 1:24 a.m.

 Thanks william!! I knew about this by converting Date into text and then importing, This is how exactly i have done but i was looking for something to import Date without changing its type but unfortunately i didn't find anything.

One other answer

Permanent link
Sunil Kumar R
JAZZ DEVELOPER (1.1k●1●33●44) Mar 23 '15, 6:44 a.m.
 Naveen, the document Exporting dateTime (timestamp) values into Rational Quality Manager through the RQMExcelWordImporter plugin might help..

Thanks, Sunil

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,946

Question asked: Mar 19 '15, 1:01 a.m.

Question was seen: 3,728 times

Last updated: Mar 23 '15, 6:44 a.m.

Confirmation Cancel Confirm