Date and time search extract on array

[Balaji_DP]

hi,

           i doing datalogging for such datas as date and time wise. i need to extract my set of data, which i want to specified date and time from and to.

here im attached my sample data looging format. please find this attachment and tell some ideas how to do?..

balaji dp

[Mathan]

forgot the attachment?

Mathan

[Balaji_DP]

sorry

[MikeS81]

Hi balaji dp,

use the "read from spreadsheet file" function, index the first column and search for your specified data and time.
Hope it helps.

Mike

[Balaji_DP]

i tried this too... but search index return -1 only....

i am using time stamp control..  then i formated to my date and time format. 

thing is that it is not match sec. character.... thats why its returning -1...

suggest me which type of formate i can use for this.......

i neet to extract specify set of datas...

balaji dp

[MikeS81]

Hi Hi balaji dp,

use something like this, the result is "1".

Mike

Message Edited by MikeS81 on 06-03-2008 12:46 PM

[indrajit]

hi balaji dp it is very simple to do it. first u extract the data by date then go for time search... u can easily do it. what may be the size of the data.

[MikeS81]

Hi balaji dp,

here is another example.

Mike

Message Edited by MikeS81 on 06-03-2008 01:08 PM