Solved

Automatically select zulu time

Posted on 2013-12-03
6
384 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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 49

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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

Suggested Solutions

Title # Comments Views Activity
How to Suppress/Hide Options on the Access 2013 Ribbon 'FIle' tab 14 39
On Key Down Access 2010 6 41
Problem with vba code 4 42
Use after update to change dates 2 16
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

832 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