The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
203 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 ...
8
votes
4answers
1k views

Put a text in front of every new line that a program prints to stdout

So I want to do some logging and therefor, want to put a date in front of a bash script's output. The problem is that is has multiple lines of output. I am able to only put the date before the whole ...
1
vote
0answers
2k views

Excel conditional formatting, greater than a year

I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates. I would like if over 3 years ago, if over 2 years ago, if over 1, ...
13
votes
3answers
593 views

How to insert the date into vim

In vim you can execute comands with "!". You can combine that with "r" to insert the output into your current buffer. :r!date Fri Jul 20 09:39:26 SAST 2012 will insert the date into a file. ...
1
vote
0answers
140 views

ms excel 2010 in windows xp - when open workbook the data is formatted differently than when i saved it

I haven't been able to find an answer to this. I have multiple files that I use regularly in excel that now have cell formats of "date". Every single cell in the entire workbook (all sheets) is ...
0
votes
0answers
219 views

Copying From Windows to NFS: Can The Timestamps Be Preserved?

We have a Linux server that has NFS shares. Some Windows hosts (XP & 7) connect to it via Services for UNIX. I've been told the behavior is different from XP to 7 in terms of file creation dates ...
0
votes
1answer
717 views

How can I convert LDAP Timestamps in Libra Office to a date time format

If I query the directory, I get the following results. ldapsearch2.4 -x -b "dc=localhost,dc=com" "cn=auser" "+" | grep stamp createTimestamp: 20100407122221Z modifyTimestamp: 20100407122221Z ...
1
vote
2answers
164 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 | ...
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
79 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" ...
-1
votes
1answer
3k views

Calculate age in days/months/years in OpenOffice

In need to find the age in days - months - years in OpenOffice. There is DATEDIF() in Microsoft Excel. You can use it to find the difference in days/months/years between two dates. Age Calculation ...
0
votes
0answers
573 views

Linux stuck one hour ahead (CentOS)

I use CentOS, and for some reason, one of the servers I bought (amongst a network of other servers I do not own) is off by one hour. The time is one hour ahead no matter what time zone I set it to. ...
2
votes
2answers
1k views

Set relative time using command line

Using something similar to the date command, is it possible to set the date and time relative to 'now'? So instead of something like date +%T -s "10:13:13" something like date -s +1h or something ...
2
votes
1answer
365 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
207 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 ...
9
votes
3answers
7k views

How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?

I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08, but Excel automatically converts the date format to 4/8/2012. I tried scrolling through the different types of ...
1
vote
1answer
328 views

UTF/unix time conversion in access

I am fairly good with access/excel/etc. However I am running into a brick wall with a database I query regularly for information. It has date/time fields that are tracked in unix time format (number ...
4
votes
11answers
21k views

How to stop Excel Treating US dates as UK dates?

I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
2
votes
1answer
501 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 ...
1
vote
2answers
3k views

How to override date format in regional and language options?

In Windows-XP, It's not possible to display the date format in DD/MM/YYYY, because it wasn't available in the regional and language options.The following image'll illustrate my problem. So i'm ...
0
votes
1answer
49 views

Show the date on pictures

I have pictures, each with a date-taken tag. How do I "stamp" that date onto the picture? (For example editing the picture, putting the date onto the actual picture, not just an overlay...)
1
vote
1answer
1k 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?
0
votes
1answer
912 views

Creating a column of working days in LibreOffice Calc

In LibreOffice Calc, I would like to create a column of working days, for example: [...] 2012-01-30 [Monday] 2012-01-27 2012-01-26 2012-01-25 2012-01-24 2012-01-23 [Monday] 2012-01-20 2012-01-19 ...
12
votes
3answers
1k views

Is it possible to determine when a NTFS partition was created?

We have a client where it would be very useful to determine WHEN a drive was a initialized or an NTFS partition created. Is there a timestamp value somewhere? If anyone could shed any advice it ...
4
votes
3answers
4k views

How to get the dates of the current monday, wednesday and friday of the current week in excel?

I'd just like a simple formula to return the date for the current Monday, Wednesday and Friday based on the current date. So, I would like to see it like: Cell A1 I'd like (Today is Monday ...
3
votes
1answer
2k views

Excel conditional formatting to highlight entire row if one date is not equal to another date in that row

I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a 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: ...
1
vote
3answers
250 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 ...
2
votes
1answer
4k views

What excel formula can I use to calculate the 2nd Monday of a given month?

What excel formula can I use to calculate the second Monday of a given month? You can assume I have a cell containing the first day of the month to work with. In the interests of other users, can ...
0
votes
1answer
1k views

How to convert decimal years into a date (format dd-mmm-yyyy or similar) in either Excel or SPSS?

I've found a fair number of formulas online which let me convert birthdate into decimal age in years but I can't find something that converts, for instance, 1.0 into 04-Nov-2011. Any help would be ...
0
votes
0answers
212 views

Why does exiftool make the current date and time shift?

When I try to shift the date and time using exiftool on both OS X and Windows I get the same outcome: the current date and time changed instead of adding 2m 18d 11hr 14m 0s. exe file and command run ...
4
votes
1answer
52 views

Word mixing up dates (1923 becomes 2023)

Using windows 7 I find that MS-Word is reffering to the system settings to interpret data. In one of the apps I use, a date is exported with a 2 digit year, even though the setting in that application ...
1
vote
2answers
17k 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 to change the hour to be UTC/GMT +1? Best Regards,
0
votes
3answers
5k views

Ubuntu clock is wrong and I can't change it (running as VirtualBox Guest under OSX)

I have a strange problem with my Ubuntu Natty virtual machine running under VirtualBox on OSX. One day last week, my clock on the top bar in Gnome stopped displaying the correct time (I'm not running ...
12
votes
2answers
8k views

How do I parse a nonstandard date format in Excel?

I have a column of date-like string values in the format yyyy-mm-dd, such as 2011-Sep-13. I need to convert these to Excel date serial numbers so that I can use them in formulas. DATEVALUE isn't ...
1
vote
2answers
451 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 ...
2
votes
4answers
283 views

How to cd to a newly created dir?

cd "$(mkdir -v "$(date -R)"|sed s+.`(.*)'.*)" This is meant to create a dir named $(date -R). I could simply cd $(date -R), but the culprit is the date could change since the previous command was ...
3
votes
2answers
346 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
6answers
17k 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
381 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?
21
votes
7answers
125k 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
815 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
272 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
8k 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
194 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 ...
1
vote
2answers
1k views

How do I list files modified on or before particular date?

Using linux commands , is there way to list files which are created an hour (or particular date) before ?.
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
249 views

Auto include save date in filename?

Can I set an option to automatically include the save date in an MSWord filename?