Hi All
How do I change this 958778695 to a date
Printable View
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.
Hope this helps you :),Code:Temp = Format("36826","dddd dd mmmm yyyy", vbMonday, vbFirstJan1)
'Now, Temp will contain the date of today...
WP