ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

Home Community Discussion Forums Most Active Software Boards LabVIEW Topic

LabVIEW

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Convert integer to date

Solved!
Go to solution

Convert integer to date

‎12-10-2013 09:54 AM

Hello.

I have a question. I am importing some data from an excel file and a column of the data is in the date format. In LabView I am reading a number for example 4577. I know that the excel time reference is different from the labview reference and I am using this conversion factor:

lv.jpg

However my problem is that I do not know how to convert this number into a date string in the form DD/MM. I just want to display in LabView.

Any help would be appreciated.

 

0 Kudos
Message 1 of 3
(3,602 Views)
Reply

Re: Convert integer to date

‎12-10-2013 09:57 AM

see here


"Should be" isn't "Is" -Jay
0 Kudos
Message 2 of 3
(3,598 Views)
Reply
Solution
Accepted by luisgepeto

Re: Convert integer to date

‎12-11-2013 07:23 AM - edited ‎12-11-2013 07:24 AM

luisgepeto wrote:

However my problem is that I do not know how to convert this number into a date string in the form DD/MM. I just want to display in LabVIEW.

Just set the Display Format of a numeric indicator to "%<%m/%d>T".  LabVIEW will take the time and format figure out your month and day for you.


There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 3 of 3
(3,549 Views)
Reply