How to change number to daet

Hi All

How do I change this 958778695 to a date

CDate will convert a date like expression into a date format, but I dont think it would change that number into a date.

This is in a text file and the documentation says it is the date/time the line in the file was written.

As of yet I have not be able to determine how to convert it

You can use the Format function. But, there is a limit: 2958465 is the same as the 31 december of 9999. You can not go higher as this number.

Code:

---

Temp = Format("36826","dddd dd mmmm yyyy", vbMonday,  vbFirstJan1)
'Now, Temp will contain the date of today...

---

Hope this helps you :),
WP