The tag has no wiki summary.

learn more… | top users | synonyms

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 ...
0
votes
3answers
3k views

How autofill all rows between two dates in excel with the second date as the incrementing limit?

That title might have made my issue sound more complex than it is... I am trying to figure out take one cell.... say A1 and put a date in it.... then move down several thousand rows and give another ...
0
votes
1answer
3k views

linux “date -s” command not working to change date on a server

date +%T --set="12:19:06" 12:19:06 date Mon Nov 26 12:37:32 SAST 2012 date 112613232012 Mon Nov 26 13:23:00 SAST 2012 date Mon Nov 26 13:42:27 SAST 2012 I have tried many different forms of this ...
1
vote
3answers
580 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
3answers
9k 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. ...
0
votes
1answer
308 views

How does `date` calculate time zone offset? [closed]

If I set the time zone environment variable: TZ="Foo/Bar", how does date handle different time zones and display the date accordingly?
3
votes
1answer
943 views

How can I batch shift the creation date of files on OS X 10.6.8?

Please note that I am not asking how to change the creation date of a bunch of files to a given date. I want to shift the date by a given amount of time, for example 47732400 seconds. Can I ...
0
votes
1answer
76 views

How do I search for a fixed date field in OpenOffice Writer?

Apache OpenOffice.org writer 3.4.1. I have a large file with many fixed date fields. (Menu: Insert/Fields/Date, and/or AutoText from such a field.) How do I search by field value? The Find (Find ...
0
votes
2answers
543 views

Formula to calculate the 5th [day of the week] when applicable

I've used the following formula to get the nth xday of the month: =DATE(B2,A2,1+7*n)-WEEKDAY(DATE(B2,A2,8-xday)) where year is in B2 and month (as a number from 1 to 12) is in A2, and where xday is ...
0
votes
2answers
261 views

Set Linux date with ddmmyy

I need to set the date of a Linux box with a string I get from a program. This string is formatted as ddmmyy. Is it possible to use that directly or do I need to reformat it first? Currently I have ...
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?
23
votes
2answers
1k views

Why are Excel weekdays wrong for 1900?

This question is based on the observations of AdamV in his answer on How do I get the day name into a cell in Excel? When A1 has the value 2009-08-01, then: =WEEKDAY(A1) will obtain 7 =TEXT(7, ...
3
votes
2answers
923 views

Edit date field code on multiple Word Documents

I have multiple word documents that have a date field code displaying the current date. I need a way to modify each document so that it shows the CreateDate field instead of Date. The format for each ...
0
votes
1answer
291 views

Display date serial number using TEXT in IF

I am using an IF function to insert a string into a cell if the cell specified is #N/A, the function works if I use the following =IF(AS2="#N/A","",CONCATENATE("insert in tempTable ...
1
vote
1answer
182 views

Excel Date Formula with a condition

I have 3 fields in excel as follows: Cell A1=2012 A2=12 A3=15 which contains year, month & date value respectively. And I want to make a date string out of it. I know it's very easy to achieve ...
2
votes
2answers
6k 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 ...
1
vote
1answer
289 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
1answer
306 views

How to use the current date as an argument?

I have a batch script which extract SQL data to CSV file: bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c I need the name of the output file to contain the current date. For ...
3
votes
1answer
5k views

Open Office Calc: Convert a date to timestamp

I have a column with dates in M/D/Y like this: 8/8/2007 8/9/2007 8/10/2007 8/13/2007 8/14/2007 8/15/2007 8/16/2007 I would like to convert them to a unix timestamp (in a new column). Would anyone ...
3
votes
1answer
3k views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...
1
vote
1answer
318 views

Picasa has re-edited all my photos randomly

I use Picasa to manage my photos. I recently switched from a Windows machine to a Mac, so I used an external hard drive to transfer my photos from the old computer to the new. Everything was fine at ...
1
vote
2answers
248 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
2k 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
3k 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
813 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
165 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
248 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
946 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
176 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
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" ...
-1
votes
1answer
4k 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
649 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. ...
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
397 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
227 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 ...
10
votes
3answers
10k 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
414 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
12answers
29k 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
572 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
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
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?
0
votes
1answer
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 ...
13
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
7k 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
286 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
7k 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 ...