converting Zulu time to PST using Access 2003

[Sheri]

I am using access 2003, not a programmer. i have a database with zulu times
and want to convert to PST. I have used the hour('h',-7,zulutime) to do the
conversion but it only works on zulu times up until 12 AM. The data I have
is for a given day Pacific time. It starts at 5 AM PST (12 PM zulu) and goes
thru 11 PM PST. hence my problem. can you help me out?

 

[BruceM]

I'm not sure why that worked at all. See Help for information about
DateAdd. You could put something like this as the control source of an
unbound text box:
=DateAdd("h",-7,[zulutime])

This will probably show you the date and the time, including seconds.
Adjust the format as needed, either by selecting a preset format for the
Format line on the Format tab of the text box Property Sheet, or by entering
your own format such as:
dd-mmm-yyyy hh:nn AM/PM

Help has more information about Format. However, it is very convoluted,
even by Microsoft standards. You could try searching for Properties, then
going to Format Date/Time Values, but when I checked just now the link does
not work. Another option is to open the VBA editor (an easy way to do that
is to press Ctrl + G), then search Help for Format Property. Follow the
link, then click Date/Time Formats.

 

[Sheri]

Thanks Bruce. I need to find out if my data actually was collected and
processed as a single day relative to PST (data was acquired in Los Angeles)
and just converted to zulu or if the data was collected relative to UTC and
takes the name of the 1st or 2nd day (TBD). For now, will assume it's
relative to PST and just used the format to long time to get rid of the funky
date the function created.

I'm not sure why that worked at all. See Help for information about
DateAdd. You could put something like this as the control source of an
unbound text box:
=DateAdd("h",-7,[zulutime])

This will probably show you the date and the time, including seconds.
Adjust the format as needed, either by selecting a preset format for the
Format line on the Format tab of the text box Property Sheet, or by entering
your own format such as:
dd-mmm-yyyy hh:nn AM/PM

Help has more information about Format. However, it is very convoluted,
even by Microsoft standards. You could try searching for Properties, then
going to Format Date/Time Values, but when I checked just now the link does
not work. Another option is to open the VBA editor (an easy way to do that
is to press Ctrl + G), then search Help for Format Property. Follow the
link, then click Date/Time Formats.

I am using access 2003, not a programmer. i have a database with zulu
times
and want to convert to PST. I have used the hour('h',-7,zulutime) to do
the
conversion but it only works on zulu times up until 12 AM. The data I
have
is for a given day Pacific time. It starts at 5 AM PST (12 PM zulu) and
goes
thru 11 PM PST. hence my problem. can you help me out?

 

[BruceM]

I really have no idea what you are saying, but it sounds as if you got
something to work the way you want it somehow.

Thanks Bruce. I need to find out if my data actually was collected and
processed as a single day relative to PST (data was acquired in Los
Angeles)
and just converted to zulu or if the data was collected relative to UTC
and
takes the name of the 1st or 2nd day (TBD). For now, will assume it's
relative to PST and just used the format to long time to get rid of the
funky
date the function created.

I'm not sure why that worked at all. See Help for information about
DateAdd. You could put something like this as the control source of an
unbound text box:
=DateAdd("h",-7,[zulutime])

This will probably show you the date and the time, including seconds.
Adjust the format as needed, either by selecting a preset format for the
Format line on the Format tab of the text box Property Sheet, or by
entering
your own format such as:
dd-mmm-yyyy hh:nn AM/PM

Help has more information about Format. However, it is very convoluted,
even by Microsoft standards. You could try searching for Properties,
then
going to Format Date/Time Values, but when I checked just now the link
does
not work. Another option is to open the VBA editor (an easy way to do
that
is to press Ctrl + G), then search Help for Format Property. Follow the
link, then click Date/Time Formats.

I am using access 2003, not a programmer. i have a database with zulu
times
and want to convert to PST. I have used the hour('h',-7,zulutime) to
do
the
conversion but it only works on zulu times up until 12 AM. The data I
have
is for a given day Pacific time. It starts at 5 AM PST (12 PM zulu)
and
goes
thru 11 PM PST. hence my problem. can you help me out?

 

[Sheri]

I did. Thanks.

I really have no idea what you are saying, but it sounds as if you got
something to work the way you want it somehow.

Thanks Bruce. I need to find out if my data actually was collected and
processed as a single day relative to PST (data was acquired in Los
Angeles)
and just converted to zulu or if the data was collected relative to UTC
and
takes the name of the 1st or 2nd day (TBD). For now, will assume it's
relative to PST and just used the format to long time to get rid of the
funky
date the function created.

I'm not sure why that worked at all. See Help for information about
DateAdd. You could put something like this as the control source of an
unbound text box:
=DateAdd("h",-7,[zulutime])

This will probably show you the date and the time, including seconds.
Adjust the format as needed, either by selecting a preset format for the
Format line on the Format tab of the text box Property Sheet, or by
entering
your own format such as:
dd-mmm-yyyy hh:nn AM/PM

Help has more information about Format. However, it is very convoluted,
even by Microsoft standards. You could try searching for Properties,
then
going to Format Date/Time Values, but when I checked just now the link
does
not work. Another option is to open the VBA editor (an easy way to do
that
is to press Ctrl + G), then search Help for Format Property. Follow the
link, then click Date/Time Formats.

I am using access 2003, not a programmer. i have a database with zulu
times
and want to convert to PST. I have used the hour('h',-7,zulutime) to
do
the
conversion but it only works on zulu times up until 12 AM. The data I
have
is for a given day Pacific time. It starts at 5 AM PST (12 PM zulu)
and
goes
thru 11 PM PST. hence my problem. can you help me out?