Tag Info

Hot answers tagged

10

In the right hand side of the gmail search bar there is a drop-down arrow- click it. The drop-down includes a date range option, and you should be all set from there


6

Yes. Use Conditional Formatting with three rules: (Format -> Conditional formatting) "Date is before" "in the past week" -> red "Date is after" in the past week" -> green "Date is" "in the past week" -> orange This will colour all dates more than a week away in green, all dates coming in the next week orange and the remainder of the dates in red. Empty ...


5

I think I've got the solution for you. It's not done all automatically, but it will result in your proposal: In your file the date is written as MM-DD-YYYY. I made the assumption that the date range covers december and NOT random dates throughout the year. Therefore I had to re-arrange the date format to DD-MM-YYYY. As a guidance I used the following ...


4

Go to Settings (Cog wheel on the upper-right side) Search for Date format Switch to 31/12/2012 Click Save at to the or bottom of the settings page


4

Google recently updated the document revisions and they are displaying the exact date for each of them. For older documents it doesn't seem to be working, but at least all your new documents will be the way you wanted it.


4

It’s possible to insert todays date through a macro. Open your Google Document and under Extra select Scripteditor. This opens Google's script editor where it’s possible to create macros for Google Documents. Paste this script and save it as Date Macro or something: (also available here) ** * The onOpen function runs automatically when the Google Docs ...


3

In MS Excel try this: =A1+TIME(2,0,0) Same with Google: =A1+Time(3,0,0) Adds 3 'Hours', 0 'Minutes', 0 'Seconds' to the date/time value of A1 Additionally if only you use the main sheet you can go into the sheet settings and change it's timezone accordingly.


3

Formatting is not the answer, because it doesn't affect the underlying values. You need to make the values updatable instead. One way is to make a reference-data place somewhere in one of your sheets (or maybe add a new sheet just for that), and put the year value in there. Then in the first cell where you want the date values to appear, use this ...


3

Once you preform the Google search, you can click on More search tools and then Custom Range... This will use the publication date, which Google describes as: Limit results according to when they were published on the Web. Google tries to estimate the publication date for a page by using information such as the date when Google first indexed ...


3

Yes, you can. Go to Google's Advanced Search Page Expand the Date, Usage Rights, NumericRange, and More section Choose from the following options Past 24 hours Past week Past month Past year OR Do a regular Google Search Expand the Show Search tools on the left underneath the search field Choose from the following options. Before: These ...


2

It seems that this is standard functionality but only with a later version of MediaWiki than what we currently have. Wikipedia, for example, does have this functionality.


1

The following custom function will transform the string date notation into a date notation: Code function myDate(range) { var output = []; for(var i=0, iLen=range.length; i<iLen; i++) { var rSplit = range[i][0].split(" "), corr = 0; if(rSplit[4].substring(5,7) == "PM") { corr = 10; } var month = parseInt(new ...


1

Use this to add the dates: Code function onEdit(e) { var aCell = e.source.getActiveCell(), col = aCell.getColumn(); if(col == 2 || col == 4 || col == 6) { var adjacentCell = aCell.offset(0, 1); var newDate = Utilities.formatDate(new Date(), "GMT+1", "dd/MM/yyyy kk:mm:ss"); adjacentCell.setValue(newDate); } } Example I've ...


1

This is not a per-site setting, but a user setting (as a user of Sites). Follow these instructions to change your time-zone preference: Go to http://sites.google.com (where you see the list of your sites) Click on the settings (cog) button and choose 'User settings'. The User settings page has a dropdown for choosing your time-zone. Change it to 'Central'. ...


1

1.) I don't know if there's a way to do that, except by writing some scripts (which can get pretty complex and probably not so reliable) There's a simpler workaround, though. You could: add a new column to the table, next to the date store the difference (in days) between that date and today (for example, if the date cell in the first row is C2, you could ...


1

This is what can be found on Googles Help page regarding this toppic: http://www.google.com/support/forum/p/Google+Docs/thread?tid=3a2ef6654058bbfd&hl=en So it seems, there is no better way.



Only top voted, non community-wiki answers of a minimum length are eligible