Help converting from VB6

[jjjamie]

I am trying to convert some code from VB6 to VB.NET and I have it all working apart from one line...

lDate = CLng(ChkDate) ' Convert date to Number

For July 20th, 2003 the above line gives 37823. Does anyone know what is the equivalent .NET code?

 

[Iceplug]

Use the DateTime.ToOADate.

lDate = Convert.ToInt64(chkDate.ToOADate)

 

[jjjamie]

Thanks! It works a treat!