S
Scott
I need the STARTTIME below formatted to display two separate fields in a
query. Field1 will be NewDate and Field2 will be NewTime. The STARTTIME is
from a GPS device in GMT. I need the new date and time to display in current
time (GMT minus six hours or MST). Also, when the GMT is 00:00:00 through
06:00:00 the date needs to change because when 2008-05-14 at 02:00 AM is
adjusted to MST the date and time become 2008-05-13 at 8:00 PM. I’ve noted
the times where the date needs to change.
STARTTIME NewDate NewTime Notes
2008-05-21T10:17:49Z Convert to 5/21/2008 4:17 AM
2008-05-17T13:09:13Z Convert to 5/17/2008 7:09 AM
2008-05-14T02:00:44Z Convert to 5/13/2008 8:00 PM Notice Date change
2008-05-10T15:05:42Z Convert to 5/10/2008 9:05 AM
2008-05-07T10:38:00Z Convert to 5/7/2008 4:38 AM
2008-05-05T10:57:19Z Convert to 5/5/2008 4:57 AM
2008-05-03T12:49:22Z Convert to 5/3/2008 6:49 AM
2008-05-01T10:58:57Z Convert to 5/1/2008 4:58 AM
2008-05-01T01:52:07Z Convert to 4/30/2008 7:52 PM Notice Date change
2008-04-29T01:25:58Z Convert to 4/28/2008 7:25 PM Notice Date change
2008-04-26T11:49:02Z Convert to 4/26/2008 5:49 AM
2008-04-25T23:51:03Z Convert to 4/25/2008 5:51 PM
2008-04-19T11:36:45Z Convert to 4/19/2008 5:36 AM
2008-04-17T23:41:01Z Convert to 4/17/2008 5:41 PM
2008-04-16T02:05:20Z Convert to 4/15/2008 8:05 PM Notice Date change
Thank you,
Scott
query. Field1 will be NewDate and Field2 will be NewTime. The STARTTIME is
from a GPS device in GMT. I need the new date and time to display in current
time (GMT minus six hours or MST). Also, when the GMT is 00:00:00 through
06:00:00 the date needs to change because when 2008-05-14 at 02:00 AM is
adjusted to MST the date and time become 2008-05-13 at 8:00 PM. I’ve noted
the times where the date needs to change.
STARTTIME NewDate NewTime Notes
2008-05-21T10:17:49Z Convert to 5/21/2008 4:17 AM
2008-05-17T13:09:13Z Convert to 5/17/2008 7:09 AM
2008-05-14T02:00:44Z Convert to 5/13/2008 8:00 PM Notice Date change
2008-05-10T15:05:42Z Convert to 5/10/2008 9:05 AM
2008-05-07T10:38:00Z Convert to 5/7/2008 4:38 AM
2008-05-05T10:57:19Z Convert to 5/5/2008 4:57 AM
2008-05-03T12:49:22Z Convert to 5/3/2008 6:49 AM
2008-05-01T10:58:57Z Convert to 5/1/2008 4:58 AM
2008-05-01T01:52:07Z Convert to 4/30/2008 7:52 PM Notice Date change
2008-04-29T01:25:58Z Convert to 4/28/2008 7:25 PM Notice Date change
2008-04-26T11:49:02Z Convert to 4/26/2008 5:49 AM
2008-04-25T23:51:03Z Convert to 4/25/2008 5:51 PM
2008-04-19T11:36:45Z Convert to 4/19/2008 5:36 AM
2008-04-17T23:41:01Z Convert to 4/17/2008 5:41 PM
2008-04-16T02:05:20Z Convert to 4/15/2008 8:05 PM Notice Date change
Thank you,
Scott