Thread: [Solved] Mail Merge and GMT/UTC Dates
View Single Post
 
Old 05-05-2011, 05:45 AM
dev98 dev98 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: May 2011
Posts: 2
dev98 is on a distinguished road
Default Mail Merge and GMT/UTC Dates

Hello All,

I have the following issue and I could not find anything about it on the web.
I have a Date Time field in my DB and it is always stored in GMT/UTC time (for example 17.06.2011 03:59:59)

When I do the mail merge to that field, it displays the date and time as is in the DB. What I actually want is to convert it to the machine's local time zone. Is that possible with Mail Merge?

Thanks very much in advance for any help
Reply With Quote