time stamp to number function

[parker_irvine]

The Conversion VIs and Functions palette has a function that converts the number of seconds elapsed to a time stamp (To Time Stamp Function).  I need to go in the other direction, from a time stamp to a double (number of seconds elapsed since 12:00 a.m., Friday, January 1, 1904 Universal Time).  Does anyone have a function to do this?  I've tried to type cast with no success.

[smercurio_fc · Accepted solution]

Just use the To Double Precision Float function. It's polymorphic and it will accept a timestamp to return the number of seconds since the LabVIEW "zero-time".

[Barionics]

That is really helpful. Now,  how do I convert the numeric back to a timestamp?

[Barionics]

OK, I'll answer my own question.  There is a VI called 'To Timestamp' in the time pallet which does the job beautifully. 

[Muni06]

Hi,

I need your help. I want to collect timestamp in format of  03/24/2016 07:20:01  for each of data. I did coding in a way as timestamp file. But my output data is different format. It shows fraction in second value. I changed it several ways and it did not work. Can you please help me?

[billko]

Why don't you post your vi instead of two pictures that have absolutely no relation to each other?

[crossrulz]

What format are you saving the file in?  Could you give us a VI so we can see your settings for the Write Measurement File?

[RTSLVU]

You do know that you can right click on the top of a column in Excel and select "Format Cells" and chage the time/date format in your spreadsheet, right?

Personally I just dump the "raw number" into excel and format it like I said above because I may or may not want the date included.

I use this little VI to add a time stamp to data as I save it.

As I said the raw time stamp will look like this in Excel

With a couple clicks of the mouse in Excel it can look any way you want.

  

[Muni06]

Thanks.

But I guess, I have another problem. I need to collect data for every second and write to file. But how can I control the time in write to measurement file?

When I collect data as the attached file it gives the data in every 0.833second. But I need to collect for each second. My question is how to write measurement file every second?

[RTSLVU]

You need a timer in your loop so it only reads the frequency and saves it once per second