Working with Php Dates

I am using Jax Calendar, a free php Calendar. I wanted to display the upcoming events on my front page, separate from the calendar module, but the date is stored as a text, something like “1096761600″, after much research, it was determined that this is the number of seconds since 1970. If you are using MS-Access & ODBC, you need a function like this to convert the string to a date.

Function DatefromUnix(strIn As String) As Date
Dim lngSeconds As Long
lngSeconds = strIn
Dim datStart As Date
datStart = #1/1/1970#
Dim dblDays As Double
dblDays = lngSeconds / 60 / 60 / 24
DatefromUnix = dblDays + datStart
End Function

This entry was posted in Uncategorized by matt. Bookmark the permalink.

Comments are closed.