converting time stamp to double

[nevica]

Hello,

I am currently using the write to spreadsheet file.vi to save data.

It looks something like this:

I also want to add the date and time stamp into the saved data but do not know a way of converting a date and time stamp to 'double format'. When the date and time stamp is in teh double format I can easily concatenate the data stream with the 'date and time' in a 2-D array.

Thanks,

Nevica

[aeastet]

Look on the math palette.

[nevica]

What I would like to do is convert a date and time stamp (which has the form something like this: xxxx/xx/xx  xx:xx:xx) to a 'double'. The problem I am having is the non-numeric characters.

[aeastet]

Like this

[nevica]

Hello,

Thanks for your example. BUT in your example your are converting a number to a double precision float. I want to convert a string to a double. The problem I am having is the formatting of the date and time stamp which includes '/' (forward slashes) and ':' (colons).

Any ideas anyone?

Thanks,

Nevica

[aeastet]

try this

[lmtis]

Could you not use "Get Date/Time in Seconds"?

Jim

[Dennis_Knutson]

---

@nevica wrote:

Hello,

Thanks for your example. BUT in your example your are converting a number to a double precision float. I want to convert a string to a double. The problem I am having is the formatting of the date and time stamp which includes '/' (forward slashes) and ':' (colons).

Any ideas anyone?

Thanks,

Nevica

---

You asked how to convert a timestamp - not a string.

You can use the Scan From String.

[nevica]

My apologies for not being clear.

It looks like get date and time in seconds will work as you have both suggested.

Nevica

[lmtis]

aeastet - nice icon