The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
4answers
143 views

What other archive formats save Date Created and Date Accessed?

7-Zip on Windows will save the Date Created and Date Accessed when compressing a .zip file, however it does not do this for its (referring to 7-Zip) native .7z format. Any Unix-based formats are ...
2
votes
3answers
2k views

Excel: show day of week does not work (German locale)

In on cell I'm showing the full date (like 01.01.2013 > German format) and in another cell I want to show only the day of week. So I followed the instructions from Microsoft which refer to the TEXT ...
2
votes
2answers
5k views

How do I copy recent folder/files from a network drive using a batch file?

My question may have answered someway or other but unfortunately I did not get the exact answer that I was looking for. Here is what I'm trying to do- create a folder on pc1, c:\temp1 map a network ...
2
votes
1answer
803 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 ...
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. ...
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 ...
2
votes
2answers
724 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 ...
2
votes
1answer
6k views

How can I change the default date format?

When I paste a date into Excel 2010 in the format "2012-12-07 00:00:00.000" I'd like it to be displayed by default as "2012-12-07", but it is actually displayed as "00:00.0". I know I can work ...
2
votes
1answer
4k views

How do I get the current date according to an NTP server without setting it locally?

I want to get the current date and time according to a remote NTP server, using Linux. I don't want to change the local time as a result; I just want to get the remote date, adjusted for the local ...
2
votes
1answer
395 views

How to set-up date for cron weekly backup?

I'm writing a command for cron to do automatic backups for my flashdrive. I use tar ... -N <some date> to make the backup. The issue is how to write the command which gives me the right date. ...
2
votes
1answer
3k views

Windows 7: How to display both date and time in tray *without* using large icons or increasing the height of taskbar? [duplicate]

Possible Duplicate: Windows 7 - display date using small icons As we approach the year 2012, there has to be a way to show the date and time in Windows 7 without doing any of the following: ...
2
votes
1answer
132 views

How do I convert dates from Open Office format to MS Excel format

I am trying to save a file in Libre Office as an excel file but Excel sees the data displays it as a negative number using a series of ###### symbols. I believe the problem is to do with the two ...
2
votes
1answer
659 views

Formula to add X months to a date?

How can I add X months to an existing date in iWork Numbers?
2
votes
2answers
1k views

unable to use datediff function in apache openoffice calc

I am unable to get a result by using this command =DATEDIFF('dd', '2007-08-01', '2007-09-01') in apache openoffice calc. Even using two columns of dates and using the formula ...
2
votes
1answer
567 views

Split time in arbitrary periods, EXCEL

I have a list with date and quantity of items used IE: 2009.03.18 -1 2009.06.05 -2 2009.06.22 -1 2009.06.29 -2 2009.07.14 -1 2009.07.14 -1 2009.07.14 -2 2009.07.20 -2 2009.07.30 -1 ...
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
0answers
23 views

Date types management mismatch (2-digits year) - on copy/paste user action

I find a strange inconsistency when copying-pasting dates on MS Excel, when they have a 2 digits year. I work on a machine Windows 7 Enterprise 64 bit and my Excel is a 2010 version. PROBLEM ...
2
votes
1answer
80 views

In zsh the date format for names isn't displayed properly

I don't know what's wrong or if I'm stupid or something, but I just can't get to display the date with words :( I've been trying this for hours now.. It should display Mon, but it displays a "M" ...
2
votes
1answer
223 views

What was scientifically shown to support productivity when structural organizing/accessing file and folders? [closed]

My Personal Information Management problem I have gathered terabytes of data but it has became a habit to store files and folders to the same folder, that folder could be kind of seen as a Inbox ...
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?
1
vote
1answer
2k views

How do I write a batch script to generate folders for each month, day and year?

How do I write a batch script to generate folders for each month, day and year based on user input?
1
vote
2answers
22k views

How to change the date of Linux to UTC/GMT +1?

I need to change the date of my system. I'm running a Linux CentOS 5.6. # date +%Z UTC # date Thu Oct 6 11:42:45 UTC 2011 How do I change the hour to be UTC/GMT +1?
1
vote
3answers
564 views

how to change the time format in Linux system

My Linux system has time format of UTC-5:0. How can i change it to UTC+5:30? Using date command i can able to change the time, but not the format
1
vote
1answer
280 views

Identify date/time format

I've been given some data to create some chart graphics and the dates are in a format I don't recognise. If I knew the format name I could easily look them up but initial search has drawn a blank. ...
1
vote
3answers
271 views

Linux date command is 4 minutes slow

I installed Centos onto my server and I noticed that when I compared the date command's output to time.gov (same timezones, of course), the output was 4 minutes behind. This also affects my ...
1
vote
1answer
286 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 ...
1
vote
2answers
9k views

How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL? (Still didn't got satisfactory answer)

I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type ...
1
vote
2answers
1k views

Unix Date command not working for few servers

I am trying to execute date command in unix server for yesterday. The commands tried are : date --date="1 day ago" date --date="1 days ago" date --date="yesterday" date --date="-1 day" These ...
1
vote
3answers
8k views

In Excel 2010 why can't I change the date format?

The original date is in the following format: 14/Nov/201110:53:44 I need it in this form: 14.11.2011 10:53:44 When I choose Number -> Custom -> d.m.yyyy h:mm -> OK , nothing changes. ...
1
vote
1answer
1k views

Timezone setting in Linux

I'm setting timezone GMT+6 on my Linux machine by copying the zoneinfo file to /etc/localtime, but the date command is showing the time UTCtime-6. What is the reason for this behaviour? I'm assuming ...
1
vote
1answer
32 views

Search unix drive for file modified today

Is there a way I can search an entire unix drive for a file that was modified today? I realize this could take a while, but thats not an issue
1
vote
3answers
1k views

How to Change Server Date?

How do I change a Linux web server's date through SSH?
1
vote
3answers
808 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 ...
1
vote
3answers
911 views

How to extract the time HH: MM of a cell stored as "dd/mm/yyyy hh:mm format in excel?

I.E. 01/07/2011 09:30 I would like to extract 09:30 of this cell. How I can do it
1
vote
2answers
239 views

Proper date -d “next monday”

I'm trying to write a quick script that figures out the date of the next Monday that isn't today. Although the date command accepts this expression, it appears to interpret it as equivalent to "this ...
1
vote
2answers
519 views

Excel macro date parser cannot handle single-digit days

From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function: Function GetDate(strInput As String) As Date ...
1
vote
2answers
418 views

Excel macros date format worldwide

On a Mac Mountain Lion, US locales, I'm working on a Spreadsheet with macros like TEXT(TODAY(), "yyyy-mm-dd")&" is the date" The problem is that the sheet is also used on computers set with ...
1
vote
1answer
116 views

Trouble in set the date in windows xp only after 8/2008

I'm having trouble setting the date in Windows XP. Specifications: Microsoft windows xp professional 2002 Service Pack 2 Intel Pentium 4 CPU 2.90 GHz RAM 512 MB Every time I try change my date ...
1
vote
1answer
932 views

PowerShell touch all files newer than

I have found the following question on ServerFault: Windows recursive touch command Which partially answers my question with this answer: Windows recursive touch command However, I would like to ...
1
vote
2answers
172 views

A download manager for Linux which saves downloaded files in directories by date like 2012_06_29

I've been using Download Master on Windows for years and what I liked most about it is that this program can automatically put downloaded files into directories by download date: /Downloads | ...
1
vote
1answer
2k views

How to tell when RedHat was last updated

I have a RHEL 5 server and I want to know the last date in which it was updated. Is this technically feasible? If yes, how?
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
1answer
216 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 ...
1
vote
1answer
126 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 ...
1
vote
1answer
15 views

Date command - adjusting the date works on my mac but NOT the server's shell

On my mac I can ask for the date in threes days time: Josephs-MacBook-Pro-3$date -v 3d Fri 3 Oct 2014 08:54:26 BST Josephs-MacBook-Pro-3$ but when I try that on my dreamhost server: ...
1
vote
2answers
101 views

Excel 2010: Calculate full months between dates

I have dates in two columns and I would need to calculate amount of full months between two dates. I export the spreadsheet from SAP ERP in .xls format but opening with Excel 2010. DATEDIF function ...
1
vote
1answer
87 views

Excel 2010 - Calculate dates and return a 0 if it is the current date or date passed

I need to calculate days between today and the 'Last day to offer' and have Excel return a 0 if today is the last day to offer or if the date has passed; otherwise it should return the number of days ...
1
vote
4answers
908 views

Converting text date into standard date format in Excel 2010

I've got an Excel 2010 spreadsheet that has a large number of dates for the year 2014 entered in the following format: Thursday 24th July that I need to convert into standard date time format (the end ...