Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: How to convert a date properly from string
Topic Summary:
Created On: 28-Jan-2004 20:51
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by , on Thursday, January 29, 2004 12:39 AM

Answer:
Janet,

Assuming 'indexDate' is equal to "1/1/2004" in your example, then 'intOf(indexDate)' is 'intOf("1/1/2004")', which is 'intOf("1") which will return '1'.

Then 'dateOf(1)' will return something like '12/31/69 17:00:01' (depending on your timezone).

Instead try:

o."BugCreated" = indexDate
 28-Jan-2004 20:51
User is offline View Users Profile Print this message


Janet Ma

Posts: 115
Joined: 12-Sep-2002

I am trying to import programmically from a .csv file to a module, but having trouble with dates.

I am reading in the .csv file and saving to a skip file. The CSV file looks like this:
BugNo,BugStatus,BugCreated ,BugTitle
1,Open,1/1/2004,New Bug


***** Parts of my DXL code****

string index, indexStatus, indexDate, indexTitle
....
Skip skBugDate = createString
....
strTemp = line[inStart:inPos-1]
put(skBugDate, Bug, strTemp)
...
(create a new object)

if (find(skBugDate, Bug, indexDate))
{
o."BugCreated" = dateOf(intOf(indexDate))
}

***************

My date ends up like this: 12/31/69 17:00:01 instead of 01 January 2004

Does anybody have a solution for this?

Report this to a Moderator Report this to a Moderator
 29-Jan-2004 00:40
User is offline View Users Profile Print this message


Janet Ma

Posts: 115
Joined: 12-Sep-2002

thanks! it works
Report this to a Moderator Report this to a Moderator
 29-Jan-2004 08:51
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Isn't nice to know that sometimes things are easier in DXL than you might have thought!


-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.