Thanks Dave. I did find that post but it explains how to take a date object or human readable date and convert it to unix time (UTC). I’m trying to figure out how to convert a unix timestamp (i.e. 1390530803) to a human readable date (Fri, 24 Jan 2014 02:33:23 GMT).
You can use a method similar to the following one to convert times stored as integers (e.g. unix UTC times) into a human readable format:
Function UnixTimeToString(seconds As UInt64) As String
Dim d As new Date
d.TotalSeconds = seconds + 2082844800
return str(d)
End Function
This can then be used throughout the program as:
MsgBox UnixTimeToString(1390530803)
If you wanted to change the default string format that your program uses to display dates in, you simply update the UnixTimeToString with the desired format (e.g. instead of using Str(d)).
AH the joy of dates
IF and only IF daylight is in effect on the date given (not today)
And then it has to be “the right offset” for the TZ (yay!) and some are full, half and quarter hours and the right one for the year since over the years they have changed