Search found 4 matches

by toyman61
Monday 29th April 2024 9:41pm
Forum: General
Topic: Converting UTC time
Replies: 9
Views: 1336

Re: Converting UTC time

Thanks BruceS!
I'm using your one-liner in my program. :D
by toyman61
Sunday 28th April 2024 8:07am
Forum: General
Topic: Converting UTC time
Replies: 9
Views: 1336

Re: Converting UTC time

Thanks for all replies! I just wanted to get the timezone offset so that I could adjust the hour parameter in the Date-function to reflect my local timezone. Here is the code snippet that I finally ended up with: Dim tDate As String = Format$(Now, "yyyy-mm-ddThh:nn:sstt") Dim sDate As Stri...
by toyman61
Friday 26th April 2024 10:24am
Forum: General
Topic: Converting UTC time
Replies: 9
Views: 1336

Re: Converting UTC time

But the Date()-function does not contain any information about which timezone I'm in and that is essential to me.

The UTC-time read from file is in another timezone than my local time and I need to adjust the read time to my timezone before I can use it in my program.
by toyman61
Friday 26th April 2024 7:26am
Forum: General
Topic: Converting UTC time
Replies: 9
Views: 1336

Converting UTC time

I'm reading info from a file and get date and time information on the form "YYYY-MM-DD"T"HH:MM:SS"Z (an example: 2024-04-27T09:25:00Z). Now I need to adjust this time according to my local timezone. I know that I can read the UTC time from my system with the shell-command "t...