how to compare Date/time string

[joshua qin]

I read from datalog file including Date/time string ,and want to query the special Date/time string span ,how to compare the data/time string ?

[bushman]

One way is to convert the date time string to seconds using the Date/Time to seconds vi, then doing straight math.

[joshua qin]

It is a good way ,but I find it must convert the Data/time string to Cluster for the Data/time to seconds.vi!
It is a easy way!So how to improve it better!?

[joshua qin]

It is a good way ,but I find it must convert the Data/time string to Cluster for the Data/time to seconds.vi!
It is a not easy way!So how to improve it better!?

[GerdW]

Hello Joshua,

To compare date/time you have to extract the different components (day, month, year, hour, minute, second) anyway. Why not "convert to seconds"? I think it's easier to compare one number (where you also can do other math, like calc the difference and so on) than to compare seven (?) parameters with some exceptions... If the dates are read from excel (there was a similar thread some days ago), why not convert to seconds in excel (just a format change)?

Best regards,
GerdW