T O P I C R E V I E W |
annnewman |
Posted - 01/23/2002 : 4:14:44 PM I found the technical support item that describes how to combine date and time into one column, and I am using this worksheet script: getn (Column number for date: ) date (Column number for time: ) time (Get column numbers); wcol(date)+=wcol(time);
wks.col$(date).format=4; wks.col$(date).subformat=10;
My date is in the yyMMdd format. My time is in the HH:mm:ss.### format. When I have changed the data types for these columns and run the above worksheet script, I get 00:00 for the time for every entry in my date column. If I change subformat from 10 to 14 (for yyMMdd HH:mm:ss which is the closest selection to what I really want: yyMMdd HH:mm:ss.###) I still get the time part of the date column containing 00:00:00 for all entries in the column. Nothing plots correctly.
Anyone know what am I doing wrong? |
1 L A T E S T R E P L I E S (Newest First) |
greg |
Posted - 01/24/2002 : 11:44:49 AM I suspect that your Time column is actually Text. Just because it displays in a column like time, doesn't mean Origin is treating it as Time.
Before running your script, either
- Select the 'Time' column and choose Format : Column. Change the Display to 'Time' and change the Format to 'HH:mm:ss.###'
- You can do the same thing in script:
getn (Column number for date: ) date (Column number for time: ) time (Get column numbers); wks.col$(time).format = 3; wks.col$(time).subformat = 11; wcol(date) += wcol(time); wks.col$(date).format = 4; wks.col$(date).subformat = 10;
|
|
|