Re: Timestamp to ISO 8601

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Worked like a charm! For those who might be interested, here's my built
field in a query:

Date Last Modified:
Format(DateAdd("h",7,CollectionData!TimeStamp),"yyyy-mm-dd\Thh:nn:ss\Z")

Where CollectionData!TimeStamp is my timestamp field in another table and 7
is the addition in hours to the timestamp to convert from MST to GMT.

Dave

--
______________________________
Remove "_SPAM" to reply directly.
"John Nurick" <j.mapSoN.nurick@xxxxxxxxxxxxxx> wrote in message
news:ba2ha19i74ttu4luosr8oh7t6jo300evj0@xxxxxxxxxx
> Hi Dave,
>
> If your code knows its timezone in terms of hours from Greenwich, I
> think that all you need to do is something like this air code:
>
> Dim dtZulu As DateTime
> Dim strZulu As String
>
> dtZulu = DateAdd("h", TimeZone, TimeStamp)
> strZulu = Format(dtZulu, "yyyy-mm-dd\Thh:mm:ss\Z")
>
> with a bit more fiddling if the timestamp is a string rather than a
> date/time value.
>
>
> On Thu, 9 Jun 2005 01:09:01 -0600, "David Shorthouse"
> <davidshorthouse@xxxxxxxxxxxx> wrote:
>
>>Hey folks,
>>
>> Anyone know how to convert a timestamp (e.g. 1/24/2005 12:42:14 PM) to
>>ISO 8601-compliant. Specifically, I am hoping to convert the default
>>general
>>date as above to 2005-01-24T19:42:14Z since my timestamps are in MST.
>>
>>Thanks for any ideas,
>>
>>Dave
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.


.

Relevant Pages

  • Re: Counting Occurences of Hours of the Day
    ... "Dave O" wrote: ... > Is the timestamp an Excel formatted time, or is it a text string? ...
    (microsoft.public.excel.misc)
  • Re: Timestamp Value - please help
    ... The following topic in MSDN gives an example of converting hex to string. ... Private mintEmpID As Integer ... 'Pass the timestamp to conversion function. ... I retrieve the updated TS for future updates. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [PhP - dB] About Formatting a Date Result
    ... In the MySQL database the field is set to date not timestamp as you ... foresight has stored a string date instead of a timestamp, ... and can format your date to that used, in the config files, for any user ...
    (php.general)
  • Re: yamp yet another multiline post
    ... start app timestamp ... return string from application ... app complete timestamp ... Mike Dundas ...
    (comp.lang.awk)
  • Re: yamp yet another multiline post
    ... start app timestamp ... return string from application ... app complete timestamp ... moving solaris awk to awk.old and linking xpg4 awk instead? ...
    (comp.lang.awk)