The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Date / time problem

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

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

  1. Select the 'Time' column and choose Format : Column. Change the Display to 'Time' and change the Format to 'HH:mm:ss.###'
  2. 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;

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000