The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
30 views

How to parse a date and time in the format 2012-12-12T00:00:00+00:00?

I have a CSV file with dates in the following format: 2012-06-20T00:00:00+00:00 Is it possible to parse a date or date and time in this format? The goal is to turn it into a date and time that ...
0
votes
1answer
16 views

Find the date of a Blogspot blog comment

I'm trying to find the date of comments on a Blogspot blog (which is not mine). Unfortunately, all that is listed is the time of the comment, but that information is useless without knowing what date ...
1
vote
2answers
47 views

Date autofill increments year instead of day

Earlier, when I had dates in a column like: Monday, 21 April, 2014 Tuesday, 22 April, 2014 and I extended the last cell to lower cells I could expect them to be filled with following days: ...
2
votes
1answer
94 views

How can I change Google Spreadsheets to have iso 8601 dates as default?

I would love to set my default date-setting to be iso 8601 (relevant xkcd) for all of my Google Spreadsheets. I'm well aware that I can manually change the date-format for a given spreadsheet by: ...
2
votes
1answer
56 views

How to make my Google Spreadsheet automatically calculate “days since”

I have a spreadsheet with several columns and one of them is for date (column D). How do I make the next column (E) automatically display the days passed from date in D until now on open? I have ...
1
vote
1answer
86 views

Date format in Google Spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format>number>more formats>more date and time formats, and I changed it to day-month-year. And ...
3
votes
3answers
1k views

Insert today’s date into a Google Document?

Is there a way to insert today’s date into a Google Document? I've looked under insert > ...? but couldn't find anything. Can this be done via an inbuilt function or a custom script?
0
votes
1answer
492 views

How can I use Google Spreadsheet to format Date in DD/MM/YYYY format?

First thing's first: my spreadsheet's locale is properly set to UK: If I paste in the following date: 30/09/2013 21:15 Then click Format > Number > Date time Nothing changes. I also can't ...
0
votes
1answer
99 views

List of Dates of Current & Previous Month in Google Spreadsheets

I want to have the dates of the current month and the previous month automatically get populated. So I'm using =MONTH(NOW()) to get the current month and =MONTH(NOW())-1 to get the previous month. ...
2
votes
2answers
880 views

Google Spreadsheets date and time format

I have lots of dates in the first column in the format August 23, 2010 at 11:01PM I was wondering if anyone knows a way to get them formatted in a way that I can then use for date and time ...
0
votes
1answer
1k views

Auto date added to adjacent cells when data is entered

I am trying to create a spreadsheet to track student loan outs that will automatically put the date in an adjacent cell. The spreadsheet would be set up like this: Column 1 would be "name" Column 2 ...
1
vote
1answer
171 views

How can you google search for pages updated recently? [duplicate]

I seem to recall years ago google had a feature where you could search for pages updated "last year", "last month", "last week" etc. Especially when searching through forums, is there's away to filter ...
9
votes
2answers
6k views

How can I search for Gmail messages on a particular date?

I'm searching for a message on or about a particular date and rather than scrolling through my emails to go back about a year, I'd like to know a search method to only find emails from a particular ...
0
votes
1answer
89 views

Google Sites File Attachment Date and Time

I live in the Central Time Zone. When I attach a file in my Google Site, it shows Pacific Time for the Attachment Time. Is there anyway to have it show Central Time?
1
vote
1answer
235 views

Conditional formatting for dates in Google sheets

I work at a language school and I have a column giving the students expected arrival date. I want to set conditional formatting to: Highlight in red any date that is older than 1 week Highlight in ...
2
votes
1answer
741 views

Date format in spreadsheet (google doc)

I want to create spreadsheets to record the money I spend each year. Each file is named as Cost-2012, Cost-2013,...etc. Inside each file, there are in fact 12 sheets, which are named as 01, 02, ..., ...
1
vote
1answer
2k views

Is it possible to see the date/time for a Google Drive folder for the most recent add/modify/delete time/date of something within it?

Is it possible to see the date/time of the item that was most recently changed within a Google Drive folder, without having to find that item within the folder first? When browsing Google Drive in a ...
4
votes
2answers
8k views

Facebook join date is hidden from timeline but still visible to public

I have already hidden the "Facebook join date" from my timeline (by hovering over it, selecting edit or remove (the pencil) and then Hide it from timeline). Right now, I cannot see this date if I go ...
7
votes
2answers
778 views

Analyse frequencies of date ranges in Google Spreadsheet

I have a Google Spreadsheet where I would like to compute occurrences of date ranges. As you can see in my sheet, there is a column date_utc+1 which contains almost random date data. What I would ...
2
votes
1answer
652 views

Convert a date in Google Spreadsheet?

I have a Google Spreadsheet with a date row in UTC time, such as 12/6/2012 11:14:32 I want GMT+2 local time, so how can I convert the date in Google Drive? And, if not possible, is there a way to do ...
1
vote
0answers
218 views

How to Create a Dynamic SubTables Based On Data From Another Sheet? (Google Spreadsheet)

I'm wondering if there is a way to create a sheet with dynamic subtables based on data from another sheet in google spreadsheets? Each student will use a form to enter data to sheet: "Entries" like ...
3
votes
1answer
76 views

Date posting on Fitocracy workout

I log my workouts on the same day that I do them - part of my post workout ritual. I've noticed that when I've looked back over the postings that the dates are not the same as the days I logged them ...
3
votes
3answers
5k views

Google Spreadsheets: Add 3 hours to Date value (DD/MM/YYYY 00:00:00)

I have cells with dates in this format: DD/MM/YYYY 00:00:00 and I want to add 3 hours because I'm in a different GMT zone. Is possible to use dates in a formula? Something like: 30/12/2012 22:15:00 ...
4
votes
1answer
1k views

How do I change date format at top of day in Google Calendar?

I can change the date format for most dates displayed by my calendar to Irish format, however I can’t find how to change this one. The dates at the top of each day are shown as 5/17 or Month/Day—as ...
4
votes
3answers
14k views

Advanced date logic in Google Spreadsheets

I have the folowing situation: Today is 4/9/12. I have a cell with a date in the sheet that is 4/13/12. This cell should turn red since it is within 7 days from the current date. What is a ...
3
votes
2answers
5k views

How to extend series of dates in Google Docs?

I can fill series of other types just like in MS Excel by extending column downwards, even if formula applied. But I can't extend series of dates. I succeeded few times, but usually I'm getting ...
4
votes
1answer
1k views

Normalizing and grouping dates in Google Spreadsheet

I have a spreadsheet pulling together various readings taken of hours heater has run, electricity units use for that period, and outside temperature. For the last 3 months, the electricity usage and ...
1
vote
1answer
762 views

Recommended date format for REST GET API [closed]

What's the recommended timestamp format for a REST GET API like this: http://api.example.com/start_date/{timestamp} I think the actual date format should be ISO 8601 format, such as ...
2
votes
1answer
3k views

How can I list MediaWiki users added by date?

The Special:ListUsers page allows me to view all the users in MediaWiki. Is it possible to view them by date added? (I'm sure I've done this before, but maybe it was via an extension.)
0
votes
1answer
166 views

Entering Local Date on Google Doc Sheets

If I use the shortcut CTRL+;, the date that is pasted is the server date. I have changed the settings so my Time zone is selected to my local time. Shouldn't my Local time get pasted as opposed to ...
5
votes
2answers
1k views

can I schedule to send mail later on with duration on gmail? [duplicate]

Possible Duplicate: Can I set an e-mail to send on a timer within gmail? I'd like to schedule an email at a later time and date with Gmail. Is this possible? They have many goodies in their ...
5
votes
1answer
369 views

Search Engine that will return results based on date

Is there a way to use a search engine, preferably Google, that will yield results based on a date? For example, I would like to search on a term and only return results as if I was searching for that ...
5
votes
2answers
247 views

Date criteria for Google search

Sometimes I'm looking for date-sensitive information and don't want to see results more than a certain age. Is there a way to specify this in a Google search?
11
votes
4answers
7k views

How can I find the creation date of a document in Google Docs?

I'd like to know when a document has been created, but Google Docs doesn't seem to display that information anywhere. I tried looking at the revisions, but all it displays is a relative time (2 months ...