For questions concerned with obtaining, manipulating or presenting the calendar date.

learn more… | top users | synonyms

1
vote
1answer
281 views

Inaccurate dates displayed in Excel (dates being calcuated from 1904 instead of 1900)

I have an excel spreadsheet containing a column of dates. When data is copied from other spreadsheets into this spreadsheet the dates change and become inaccurate. Changing the format of the ...
1
vote
3answers
312 views

check of date with functions lookup

i have input date in sheet1 say in A! 15/07/2010 and in another sheet range of dates with interval of six months in a1 01/01/2010 and in b1 30/06/2010 and c1 15 likewise data is there i want to ...
2
votes
1answer
1k views

Why does Windows date jump a month ahead

We have a few computers that run Windows XP and every now and again they put the date/time one month forward in time. This just happened again today, putting the date to 20th September 2010. This is ...
4
votes
1answer
9k views

Grouping dates by week in a Pivot Table

I am trying to create a Pivot table to report on data that comes from an Access Query. Basically the data that comes back is in the following format: TradeDate StoreID DeptCode ReasonCode ...
14
votes
3answers
32k views

How to display Unix time in the timestamp format?

I'm looking for a way to display my time in Debian Linux as a timestamp, e.g. 1279628325 I can't find any options to do that with the date command. Any ideas?
8
votes
4answers
13k views

Timezone conversion by command line

I know about http://www.timeanddate.com/worldclock/converter.html I can't figure out how to query http://www.google.com in a sane natural format like "5pm BST in PST". Or do I have to write such an ...
4
votes
1answer
1k views

How can I fix a date that changes by 4 years and 1 day when pasted between Excel workbooks

In Excel dates are represented internally by a floating point number where the integer part is the number of days since "some date" and the fractional part is how far into that day (hence the time). ...
1
vote
1answer
1k views

How to change time (Advanced Eastern Time) on Slackware 8.1

I have a linux (Slackware) machine and the time/date is like, June 23rd 2003, 10:00am (It's 11 here) and I am not able to set the time to have it correct. I change the timezome to Montreal but the ...
4
votes
4answers
996 views

Is it possible to know when was the last update of a dynamic (PHP/ASP) web page content?

Update: the question was not clear enough.... I have found a bookmarklet that give me the date of a web page last update: javascript:alert(document.lastModified) But it's not very effective ...
0
votes
2answers
159 views

CSV opens in OpenOffice but adds slashes?

Trying to open a CSV in open office - but it alters the data. Here is the the CSV in its raw format (opened in Notepad); 10-1001,product name 1, 10-1001-020,product name 2, 10-1001-030,product name 3,...
3
votes
3answers
4k views

Is there a way to find out when some web page was made?

Nope, it's a fine title ... Is there a way to find out when some web page was made ? (Example: I often, before buying equipment, search through reviews ... before shortening the list of "candidates"...
22
votes
7answers
36k views

Windows 7 - display date using small icons

I recently upgraded to Windows 7 and need the date displayed with the time. This works, but only if I use large icons in the taskbar settings which is quite ugly. Any ideas how to display the time ...
2
votes
2answers
755 views

How to fix iCal wrong date after snow leopard upgrade? [closed]

I searched google everywhere but could not find a fix for that annoying bug. This video shows exactly what happens: http://www.youtube.com/watch?v=hsie6lN0p8o Removing from the doc and re-adding ...
4
votes
1answer
5k views

Setting file creation date in Mac OS X

I need a script to set the creation date to the modification date for a bunch of files created by my sound recorder - any way to do this? Running Mac OS X 10.4.11
11
votes
2answers
13k views

In Windows 7, how to show day name in system tray clock?

Without installing third-party software, how do I display the day in the clock in the lower-right system tray clock in Windows 7. For example: "Tuesday" (in addition to normal time and date display)...
10
votes
4answers
3k views

Is there any software or hardware which lets you stop, slow down, speed up or even reverse time?

Obviously I'm talking about time in terms of the PC clock rather than real time. We were testing an application we've developed at work by setting the clock forward and back to simulate different ...
20
votes
3answers
28k views

how to add a day to date in bash?

For example, I have date: 4 August 1993 and I want to add 348 days to it, how can I do it in bash?
15
votes
10answers
59k views

Windows 7 System Tray Date Display Not Appearing

I'm using Windows 7 RC and for some reason, the date won't show at all on my system tray. It used to for a while, but one day it just stopped (I didn't even notice it until someone pointed it out). ...
2
votes
2answers
266 views

Vista: change clock tooltip to short date?

Is it possible to change the tooltip that shows above the clock from the "Long date" format to show the "Short date" format?