2
votes
Accepted
Search for users by timezone or country on Slack?
Slack does not store the country of a user, but it stores the timezone.
It's not a standard feature to list users by timezone, but there are a couple Slack Apps that do that nicely. Check out Team ...
- 1,814
2
votes
Accepted
How to import an iCalendar event with diferent time zones
You must define the TZIDs used in your iCal file, using the VTIMEZONE component.
For example, add this block of code after END:VEVENT to define the "Eastern Time - New York" timezone:
BEGIN:...
- 564
2
votes
Convert time zones with Google?
Seems to be working now (in 2018):
https://www.google.de/search?q=8pm+est+to+pst
https://www.google.de/search?q=18%3A30+CEST+to+GMT%2B1
- 121
1
vote
How can I Convert date from 'Mon Jun 05 2023 00:00:00 GMT+0100 (British Summer Time) to 'DD-MM-YYYY' in google APP Script
Use Utilities.formatDate(), like this:
// ...
const timezone = sheet.getParent().getSpreadsheetTimeZone();
const toDateString_ = (date) => Utilities.formatDate(date, timezone, 'dd-MM-yyyy');
...
- 15.7k
1
vote
I have the formula I want to use but now sure how to change it with time another time zone
You can use new Date(Date.UTC(year, month, day, hour, minute, sec)) to format a Date as you want it to be and delay it manually. (Ex. GMT +02, EST +.., ecc..)
Or you can use new Date().toLocaleString(...
- 11
1
vote
Accepted
How to get correct TimeZone in googlesheet using script?
To pass strings as arguments to a custom functions they should be quoted enclosed.
Instead of
=myFunctions(A1,Aisa/Tehran,"dd-MM-yyyy'T'HH:mm:ss'Z'")
use
=myFunctions(A1,"Asia/Tehran","dd-MM-yyyy'...
1
vote
Google Sheets can't understand timestamp format containing timezone information
Google Sheets date handling doesn't include a way to directly recognize date-time that include time zones, but JavaScript does it.
You could create a script to return a value that Google Sheets ...
1
vote
How to format the time in this Google Apps Script
you are calling time inside date (formatDate) without actual date format so the sheet is guessing.
var formattedDate = Utilities.formatDate(time, "GMT+2", "MM-dd-yyyy HH:mm:ss");
- 27.1k
1
vote
How to format the time in this Google Apps Script
The way that Sheets and Apps Script handle "dates" are very different.
For Sheets the "date" unit is 1 day; The base date is 1899-12-30 0:00:00, getting the timezone from the spreadsheet settings.
...
1
vote
Can I have a Google Forms automatically capture a user's time zone?
Only Google Forms for G Suite accounts can automatically capture user data but it's only able to get the user email address.
The alternative is to include a question asking for the user time zone. ...
1
vote
Accepted
How can I adjust Doodle poll time zone?
Go to your profile.
Adjust your default timezone, then it will work.
- 245
1
vote
How to set public Google Calendar embed URL to use client's local time zone?
Turn on the "viewer" timezone.
- 11
1
vote
Google Calendar all-day reminders not respecting my timezone
Now you can set when you will be notified for All-day events in the Google Calendar Settings.
Go to calendar.google.com in your browser
Click on the gear icon in the upper right and choose Settings
...
- 1,968
Only top scored, non community-wiki answers of a minimum length are eligible