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

learn more… | top users | synonyms

8
votes
4answers
3k 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 ...
16
votes
3answers
2k 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. ...
0
votes
0answers
311 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
2k 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
212 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
3answers
2k 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 =DATEDIFF('dd','A2','B2')...
2
votes
1answer
89 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" ...
3
votes
2answers
2k 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
425 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. ...
3
votes
1answer
268 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 ...
1
vote
2answers
4k 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 will illustrate my problem. So ...
0
votes
1answer
50 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
3k 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
2answers
1k 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 2012-...
15
votes
3answers
3k 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 ...
5
votes
3answers
18k 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 ...
1
vote
3answers
474 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 ...
0
votes
0answers
244 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
76 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 ...
2
votes
3answers
36k 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?
0
votes
3answers
8k 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 ...
16
votes
2answers
18k 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
706 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
301 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 ...
6
votes
8answers
40k 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 Day=%...
6
votes
1answer
847 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?
41
votes
8answers
258k 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 root@...
0
votes
1answer
1k 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, 0-...
1
vote
1answer
360 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 -...
15
votes
5answers
20k 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
4k 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
208 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
82 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
334 views

Auto include save date in filename?

Can I set an option to automatically include the save date in an MSWord filename?
5
votes
1answer
12k 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 ...
0
votes
4answers
190 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
2k 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
0answers
199 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
10k 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
6k 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
6k 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
3k 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. ...
13
votes
1answer
48k 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
279 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
8k 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
12k 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 ...