HELP!! Need help with Date 
Author Message
 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.



Tue, 08 May 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. HELP: Need help identifying DLLs with version,date,size etc

2. HELP - Need help on DATE data type

3. Date validation script needed - Please help!!!

4. Urgent Date Help Needed Please!!!

5. Date - Syntax Error- Need help

6. Need Help with Date Functions

7. Need help with date checking.

8. Date validation script needed - Please help!!!

9. Urgent Date Help Needed Please!!!

10. Need Help about Date problem !!!

11. Need Help! calculating date fields

12. help, help, help...I'm begging here :-\ RE RE POST simple code help needed

 

 
Powered by phpBB® Forum Software