Convert integer to date

[luisgepeto]

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:

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.

[JÞB]

see here

[crossrulz · Accepted solution]

---

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.