The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
2answers
390 views

Convert “Mon Aug 01 09:08:25 CDT 2011” to a usable date/time using Excel

I have a giant spreadsheet with computer names and the date stamp that they last reported into our PGP server that I need to convert to a usable date/time, so I can sort the column by the time the ...
4
votes
7answers
20k views

How to get the Date in a batch file in a predictable format?

In a batch file I need to extract a month, day, year from the date command. So I used the following, which essentially parses the Date command to extract its sub strings into a variable: set ...
5
votes
1answer
471 views

How to search in windows according to access date

I have found only according to "date modified" and not "access date" I haven't found any ways of sorting this correctly. Maybe I should use third party software?
26
votes
7answers
154k views

How to set current time on Linux?

Why is the output of the following commands different? root@vmi2115:/var# hwclock Sun 26 Jun 2011 01:21:38 PM CEST -0.273230 seconds root@vmi2495:/var# date Sun Jun 26 15:21:39 CEST 2011 ...
0
votes
1answer
904 views

Getting the week number based on date with different first day of the week in gawk

How to get the week number in linux using gawk with different first day of the week? the date command can give me the week number with +%V but it is based on Monday (1-53) or +%U (based on Sunday, ...
1
vote
1answer
284 views

On the command line, 'find' reports back an illegal time value

I want to run the following command. find . -mtime -60s When I do, I get this output instead: CLIENT% echo `date +%s`-1308741881 | bc 5152 CLIENT% find . -mtime -`echo `date +%s`-1308741881 | bc`s ...
10
votes
5answers
10k views

Store the output of date and watch command to a file

I am a newbie to linux and I am trying to watch a command and try to log it into a file. I tried watch -t -n 10 "(date '+TIME:%H:%M:%S' ; ps aux | grep "pattern" | wc -l)" >> logfile and am ...
3
votes
2answers
2k views

How to make an application detect if system time has changed in Linux

I need to write a small application which needs to detect if the system time is changed by an another application/user and perform some action as soon as it is detected (maybe log the data that time ...
0
votes
1answer
198 views

Can I set a unique date/time for a single user in Ubuntu?

Is there a way to give different users unique system date/times in Ubuntu? For example, if I wanted the date to always be June 22nd for user Bob (because that's his birthday) but still have the ...
5
votes
2answers
77 views

Formatting Dates

I have the following formula: =D56&" "&"("&D57&" Days"&")" D56 has a date within the cell. I want to format the date like 5/5/2011 but I'm not sure how to do it.
1
vote
3answers
1k views

How to Change Server Date?

How do I change a Linux web server's date through SSH?
3
votes
1answer
256 views

Auto include save date in filename?

Can I set an option to automatically include the save date in an MSWord filename?
4
votes
1answer
5k views

Put date into backup .tar.gz filename

I'd like to run a simple tar command to backup my website directory. It will run through cron, but I want to be able to put the time at which the backup was made as the filename. I don't really mind ...
1
vote
3answers
792 views

How can I convert non-standard date data in Excel?

For some silly reason the data I've been provided has dates in the following format: mmddyyyy but if the date is something beginning with zero (e.g. 03132010) then it shows up without the leading ...
0
votes
4answers
185 views

Unix script: use of date and use of for

MinuteNow=date +%M; for ((i=2;i<=57;i+=5)) do if [ "$MinuteNow" == "$i" ]; then ************* fi done The problem is for 2 and 7, the date commande output is 02 ...
2
votes
1answer
774 views

why do some emails have impossible (past) dates?

I just got a spam email dated 1970/1/1. I laughed, but then thought about it a bit more. I get these from time to time - always spam - and assumed they did this to stand out in your inbox. But I'm ...
1
vote
1answer
104 views

Stop Microsoft Excel 2007 from formatting anything?

How can I stop Excel 2007 from modifying any character, I don't want to modify the date in any way, I don't want to modify misspells, nothing. I just want to see the exact text I'm writing.
1
vote
0answers
181 views

VirtualBox guest not recognizing daylight savings transition

I want to test an app's behaviour during transitions in and out of daylight savings time. I therefore want to be able to set the date and time of a VirtualBox VM, (preferably from the Control Panel ...
7
votes
5answers
6k views

How to convert from day of year and year to a date YYYYMMDD?

I'm looking to go from day of year (1-366) and year (e.g. 2011) to a date in the format YYYYMMDD?
0
votes
2answers
4k views

Converting date format in formulas in Excel

I have a column of dates in the following format ddd mmm dd hh m:s "EST" yyyy. In another cell in another sheet, I wish to have the dates in the format dd/m/y. How can I do this? I already tried the ...
2
votes
3answers
5k views

Difference in command line date format between XP & Windows 7

The DATE command in XP gives the date in the format ddd dd/mm/yyyy e.g. Sun 12/12/2010. In Windows 7, it only gives dd/mm/yy I.e. 12/12/2010. Both have the same regional settings. Can Windows 7 be ...
2
votes
3answers
2k views

How to get date value in commandline

I need to do a command that takes yesterday date and builds it into a file path like this: copy "Something 2010-12-06\*.zip" "d:\Copy\" where 2010-12-6 is yesterday's date in format yyyy-mm-dd. ...
9
votes
1answer
17k views

Adding Weeks to Current Date in Excel 2007

How can a given number of weeks be added to the current date in Excel 2007? For example, if I need to add 12 weeks to the current date, 12/6/2010, how can that be done?
1
vote
1answer
214 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
1answer
2k views

Converting a five digit number to date format in excel?

In these spread sheets I have an entire column of values that are supposed to be dates, such as. 200701 = 1/1/2007 200702 = 2/1/2007 200905 = 5/1/2009 And so on and so forth. These will all be in ...
6
votes
5answers
25k views

Change year in many date fields in excel?

So I've noticed in a worksheet I have many dates that are four years off, no doubt because of improper copy/paste from earlier question. Is there an easy way to convert a bunch of dates I select to a ...
1
vote
3answers
305 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
867 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
6k 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 ...
2
votes
1answer
1k views

What date formats does Excel recognize as dates?

What date formats will Excel recognize as dates? I've been using Jul 30/10 11:41:10 but Excel doesn't recognize this as a date. I don't want to apply a function to the value, I just want to open ...
6
votes
2answers
18k 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?
5
votes
4answers
5k 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
627 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
384 views

How to keep windows 2003 Daylight Saving values updated

My web app runs on windows 2003 .Net 3.5 I have users from Israel (GMT +2), and Israel switched to Daylight saving time on 26/3/10 so now it's (GMT +3). I use TimeZoneInfo.ConvertTime that doesn’t ...
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 ...
3
votes
4answers
618 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
153 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 ...
1
vote
1answer
124 views

Return the date of the day under an if formula with Excel or VBA

I have two columns A and B and many lines with some specific tasks to be done. In column B, I have a drop-down list with the name of people who are scheduled for the task . And in column A, I want the ...
2
votes
3answers
3k 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 ...
17
votes
7answers
25k 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
1answer
1k views

How do I create a custom date format in footer that updates automatically in Powerpoint 2007?

I see how to add a date to the footer that updates automatically, either via "Insert->Header&Footer" or "Insert->Date&Time". Works great! However, I can't figure out how to do this with a ...
2
votes
2answers
723 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
8
votes
2answers
10k 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 ...
9
votes
4answers
2k 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 ...
13
votes
3answers
18k 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?
14
votes
10answers
46k 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
261 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?