LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Using Format Date/Time String Function Vi

Solved!
Go to solution

I don't do any special formatting for time controls, so yes, the system formatting is going to apply.

 

I'm talking about formatting a time/date into a string so that it is part of a message that a user sees on screen.  So something like "6/1/11 2:33 pm.  The machine shut down due to high temperature."

0 Kudos
Message 11 of 13
(1,467 Views)

I am rading from file and first col. is Date and time. but when I format  useing LV to date and time it gives 1904 year month date and time. I try with xls it changed to 13/04/2015 9:48:43.

 

How to format Date and time in to first col. in labview?

42107.408835659 26.39291 26.25236 26.12775
42107.408862858 26.34806 26.27714 26.12986
42107.408890068 26.33641 26.24139 26.13545
42107.408920855 26.39866 26.30673 26.17596
42107.408948066 26.35046 26.29751 26.14207
42107.408975265 26.32681 26.26007 26.17119
42107.409002464 26.40651 26.27214 26.18326
42107.409029675 26.37621 26.24455 26.18596
42107.409056874 26.35323 26.31006 26.13376
42107.409084085 26.32315 26.30338 26.10857
42107.409111284 26.3406 26.29309 26.11297
42107.409138483 26.34446 26.25995 26.11484
42107.409165693 26.37654 26.26247 26.10666
42107.409192893 26.39041 26.3079 26.10674
42107.409220092 26.34008 26.25957 26.17105
42107.409247302 26.31805 26.24497 26.18801
             
               

 

0 Kudos
Message 12 of 13
(1,238 Views)

Hi uditha,

 

you shouldn't hijack old threads. Next time please create your own thread for your own special question…

 

That being said: You need to convert that Excel time value to a LabVIEW time value.

Search for "Excel LabVIEW time conversion" here in the forum and you will find ready-to-use VIs and explanations about the algorithm used!

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
Message 13 of 13
(1,227 Views)