Ilogic Get date from excel to Custom Property

[j.romo]

We have a Project Excel sheet that goves us the delivery time to finish a Project that our PM fills with some dates for each Project we are currently developing.

I have the next code but the date on the spreadsheet comes back as numbers in the custom Iproperty, 

the custom iprop does not get any value if I set it as Date, and gives me random numbers if I set it up as Text.

We search the row by Project name

SyntaxEditor Code Snippet

Dim oPROJ As String
Dim oDATE As String

oPROJ = iProperties.Value("Project", "Project")
'oDATE = iProperties.Value("Custom", "DEADLINE")

GoExcel.Open("X:\ILOGIC\PROJECT_TEST.xlsx", "CURRENT")

For rowPR = 3 To 100

If (GoExcel.CellValue("A" & rowPR) = oPROJ) Then

 oDATE =  GoExcel.CellValue("B" & rowPR)

iProperties.Value("Custom", "DEADLINE")= oDATE


Exit For

End If

Next
GoExcel.Save
GoExcel.Close

[dgreatice · Accepted solution]

Change this line :

iProperties.Value("Custom", "DEADLINE")= Date.FromOADate(oDATE)

[#3 · Accepted solution]

iProperties.Value("Custom", "DEADLINE")= Date.FromOADate(oDATE)

[j.romo]

Hello dgreatice

Didnt work, even changing the custom property to date or text.

found a work around , In the Spreadsheet the cells have to be as text for the code to work.

Thanks a lot

[dgreatice]

Hi,

I create that code with date type in data excel, not a text type. and my iProperties  is date value, and its work for me.

[j.romo]

Thats weird

I can Share the IPT file and the XLSX file

if you want to take a look?

[dgreatice]

Yes, if no confidential.