how can I convert the following into system time format
Tue, 28 Nov 2000 23:53:20 GMT
Printable View
how can I convert the following into system time format
Tue, 28 Nov 2000 23:53:20 GMT
I thought we had but I have had to satrt completly over as I lost my hard drive and with it all my code(at work not home) so now I insist on storing all my code on my own pc so I dont lose crap Kinda ticked me off as I had the app almost done
I cant get it to work heres what i get for results the ones ending in mod are the modiified times
03 JUL 2001 21:31:13
03 JUL 2001 21:31:13Mod
and heres the exact code I use
tmp_string = Mid$(tmp_string, 6, 20)
Debug.Print tmp_string
DateAdd("h", -5, tmp_string()) = tmp_string
Debug.Print tmp_string & "Mod"
Whats wrong with it grrr I hate redoing work
thanks rye I apreciate it a great deal