
HELP!! Need help with Date
I need some help.
I am creating a website that allows my clients to pull real time data from
my SQL server. Each one of the records has a date/time stamp on it. This
is stored as the number of seconds past since Jan 1, 1970 12:00 am GMT.
I have managed to convert this to a readable format using the following.
(All I need is the date, time is not important right now)
NewDate = (SimpleTicketRecordset("Date_Time_Opened")/60/60)/24
ReadableDate = DateAdd("d", NewDate, "1-Jan-70")
LongDate=FormatDateTime(ReadableDate, 1)
What I would like to do is have 3 list boxes with Month, Day and Year to
choose from for searching purposes.
Does anyone know how to take the Month, Day and Year results and convert
them back to the number of seconds so I can run a it in a query.
I'm in a bind. My dead line is almost near and I need to produce some
results quickly.
Thanks in advance.