The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
186 views

Sudden change of date in windows 7 (From 2013 to 2039)

I was watching a video on youtube (using Chrome, OS is windows 7) when a pop up warned me that I had to calibrate my monitor again since the calibration was too old. This sounded strange, since I had ...
0
votes
1answer
60 views

Add rows to insert dates from a “from” and “to” column

I want to breakdown an Excel sheet by having it in a specific format. Right now, the sheet is like this FROM TO TOTAL 01/27/12 01/27/12 1 03/09/12 03/09/12 1 04/11/12 ...
0
votes
3answers
9k views

CountIf Formula that counts cells containing any and all dates without having a date range?

I need to simplify a CountIF formula. Instead of having a date range I just need my COUNTIF to count cells cointaining dates disregarding date range period. I have tried for example simplifying it ...
0
votes
0answers
1k views

Create a folder with current year & month, windows command line? [duplicate]

How to use mkdir to create a folder with this something like --> folder1-2013-04 (but the year and month should be dynamic and generated automatically.
0
votes
1answer
342 views

Batch script or set of commands to extract the fields of date

I am trying to create a batch file to backup my data at regular intervals in Windows using a batch script. I need date parameter and the fields from the displayed format (Month, day and year). ...
0
votes
2answers
5k views

In Lotus Notes how can you change the date format?

In Lotus Notes 8.5 how can you change the date format? I don't like 27/3/2013 and would like Wednesday 3, 2013 or the like.
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 ...
2
votes
1answer
975 views

Formula to add X months to a date?

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

How to set mergefield to show long date format?

How can I make Word 2012 display German date format in mail merge? { DATE \a "dd.MM.yy" \ * MERGEFIELD } returns 15.02.2012 for today, 15. Februar 2013 however is what I want.
0
votes
1answer
223 views

monthly totals comparing two date columns, Excel 2010

How can I calculate a monthly total of the courses completed for the month ONLY when they were due for that same month (sometimes students are late and sometimes early)? The spreadsheet has a column ...
1
vote
0answers
515 views

What format can I use in Excel to display both date and time in system formats

I need to display both date and time in system date and time formats. I know that [$-0xf800] means the system long date format and [$-0xf400] means the system time format, but [$-0xf800][$-0xf400] ...
0
votes
1answer
755 views

EXCEL populate a list of sunday's dates and ignore the sundays in an exception list

Hi i'm working on a sheet which i have to populate with sundays dates, and make sure that dates from an exception list don't be present in my final list Goal: is to have the list of dates of only ...
0
votes
1answer
508 views

ms sql select data after specific date of the year regardless of year

I want to select a data from column 'Birthday' which format is 'yyyy-mm-dd 00:00:00.000' but I need to skip year, and pull out data from range yyyy-01.01 to yyyy.05.01 ? Tryed underscores and percent ...
1
vote
0answers
294 views

Change date in a SQL query to reference a cell in Excel

I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the ...
3
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
5k 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 ...
1
vote
1answer
4k 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
647 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
10k 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
328 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?
5
votes
2answers
1k 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
83 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
594 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
288 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
999 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
319 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
202 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
329 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
380 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
6k 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
331 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
269 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
924 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
258 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
1k 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
183 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
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 ...
2
votes
1answer
83 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
682 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
401 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. ...