Solved

Automatically select zulu time

Posted on 2013-12-03
6
388 Views
Last Modified: 2014-01-04
I have an application dealing with air travel, and all times use GMT, or ZULU time.

Is there a way to autopopulate a date and time field to utilze ZULU, or GMT as a default value?

My end goal is to have the member type an entry on a form in the "Item" field, and have the date and time fields autopopulate with the Zulu time and date.

Database will be used from within several time zones, too.

Time and Date are separate fields.
0
Comment
Question by:TIgerV
6 Comments
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 39692747
0
 

Author Comment

by:TIgerV
ID: 39692823
...So implementing default value as zulu time is not possible, since all this is code values.
0
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 39693033
I don't think you want to Change all Computer times to Zulu


http://support.microsoft.com/kb/221542
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:TIgerV
ID: 39693086
No, I want to have the default value of an access field report as ZULU.

The excel example doesn't show how to do that.
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 39693801
I made a little database to convert times from one time zone to another a while back; it might be helpful here:

http://www.helenfeddema.com/Files/accarch121.zip
0
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39694829
The function DateTimeUTC is exactly for this - as listed here:

Time zones in Access: Specifying/displaying/converting

Note please, that GMT and Zulu are "old" names for UTC.

/gustav
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question