[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

Automatically select zulu time

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
TIgerV
Asked:
TIgerV
1 Solution
 
Rgonzo1971Commented:
0
 
TIgerVAuthor Commented:
...So implementing default value as zulu time is not possible, since all this is code values.
0
 
Rgonzo1971Commented:
I don't think you want to Change all Computer times to Zulu


http://support.microsoft.com/kb/221542
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
TIgerVAuthor Commented:
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
 
Helen FeddemaCommented:
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
 
Gustav BrockCIOCommented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now