From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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
(2,641 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
(2,637 Views)
Reply
Solution
Accepted by topic author 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.

GCentral
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
(2,588 Views)
Reply