Time conversion

[egiggey]

how can I convert the following into system time format
Tue, 28 Nov 2000 23:53:20 GMT

[egiggey]

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

[egiggey]

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

[egiggey]

thanks rye I apreciate it a great deal