Long Date Format Very Tricky

[mr moe]

Hi all,
I have a table that has a long date format for example 05/05/05 02:40:34 AM how can I add an 8 hours to the date and time. Please help if you can because I"m going nuts!!! thanks. I want it to look like 05/05/05 10:40:34 AM

 

[mr moe]

It's not working all I want to do is to convert GMT time to Standard time. I want this field to be converted. for example 04/04/04 03:35:22 AM will have to be converted to the date above minus five hours. can someone please help.

 

[mr moe]

Pat lets assume that the field name in my query is mytime and the table name is Test, Can you please give an example of how I would use the DateAdd function. Like I said I want to subtract or lets say add 4 hours for the mytime field. thanks.

 

[mr moe]

Thanks Pat,
but I'm getting data type mismatch when I run my query, again the field is long date format. Thanks, please advise.

 

[mr moe]

Pat just to correct something the datatype is date/time and the format is general date, I hope that can help.

 

[mr moe]

Sorry Pat it's still not working, keeps telling me type mismatch.

 

[mr moe]

Ok Pat thanks have a good night, I'm ready to go to bed too. I'll keep you posted Sir,
Bye,