Solved

Automatically select zulu time

Posted on 2013-12-03
6
392 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 51

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 51

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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

752 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