The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
111 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 native .7z format. Any Unix-based formats are ineligible. Are there any ...
0
votes
1answer
132 views

Convert datetime to another datetime format

How do I convert this datetime? [23/Sep/2013:21:18:00 +0200] to 23/Sep/2013 21:18:00
1
vote
2answers
7k 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
votes
2answers
107 views

How to set different dates to different Users in Windows7

I want to set different date for each user on my Windows 7, is there any option? or third party software? Want to change system date/time when particular user login windows. thank you
0
votes
2answers
62 views

How to Sum Date (in minutes) Shell

I need some help here, I'm not a expert with shell scripting but I am trying to do a script where I need to take the Epoch number followed by the date, but for with the all hours of the day with a ...
0
votes
1answer
132 views

DateTime to just Date

In LibreOffice, Calc under Linux, I have a table with DateTime values (eg. 2011-06-15T15:37:56+00:00). How shall I convert these values to just Date values (eg. 2011-06-15)? I suspect it is very ...
1
vote
1answer
112 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 ...
0
votes
1answer
90 views

Tar archive wrong creation date

I have a script to backup some directories: tar cjf /backup-`date +\%m-\%d-\%Y`.tar.bz2 mydir >> /dev/null 2>&1 At the end of the process, a "ls -al" show something like: -rwxr-xr-x 1 ...
2
votes
3answers
1k 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 ...
-1
votes
1answer
63 views

Explorer sort order by date (not by type) [closed]

Why Explorer in Windows 7 keeps grouping files by type when I want them by date? Each group is sorted by date (modified), but I would like all files sorted by date (mixed types, like an old'n'good ...
0
votes
1answer
47 views

Using Excel to create a date series for a job on the same 2 days every week

I want to create a calendar showing ONLY all the Wednesdays and Thursdays in a year with their date, so for example: Wed 25 Sept Thu 26 Sept Wed 2 October Thu 3 October etc. I thought it would be a ...
0
votes
1answer
1k views

System date change tracking in windows xp

I wanted to track when system time was changed in a PC.By looking at event viewer for event id 520 i will get it. But when i changed date manually in windows and look at event viewer i found 4 entries ...
0
votes
3answers
2k views

Better way to replace timestamp by date when reading a squid log

Tonight i was trying to look at my proxie's lines, and I came up with this, which seems all but KISS. How would you do it simply ? awk '{ trunc=sprintf("%.0f", $1) ;$1="" ; system("echo -n `date +%R ...
3
votes
1answer
1k views

Windows 7 Explorer Columns: meaning of “Date” in relation to “Date Modified”/“Date Created”?

I've managed to alter the creation/modified date on a large number of files that I've moved with a well known 3rd party software. The only field that seems to point to a valid period of time is ...
1
vote
2answers
376 views

Convert Day of the Year in Excel?

How can I convert Day of the Year to a mm/dd format in Excel? Date of the Year: e.g. 1= Jan 1, 177 = June 27. For example, how do I convert "177" to 6/27?
-2
votes
1answer
603 views

How to add a month to an Excel date value? [duplicate]

I tried to google for a while but it seems to have no straight forward way to do this math. For example, we have the date at B2 12/31/2012 and need to add 2 months to it and store value in B4. What ...
2
votes
4answers
3k views

How to add month to date in LibreOffice calc

This seems like an obvious question. I have a date column, and I want to create a formula to increase it by one month for each column. 10/2013, 11/2013, 12/2013, 1/2014, 2/2014, ... How do you add ...
-1
votes
1answer
265 views

Python to see if a file falls into a date range [closed]

I have a script that I want to have an if statement check if a file falls between several specified date periods as it searches directories. I have been able to get the time in %Y-%m-%d format for the ...
1
vote
0answers
188 views

Change the Default Date setting in Word 2010

I am using Word 2010 and Windows 7. You know how when you start typing a date in Word it will automatically suggest what it thinks you want? Like if I start typing “6/29”, a little grey bubble will ...
1
vote
2answers
1k views

Convert date from Taiwan to Gregorian in Excel

I've got some data from Taiwan in a .csv spreadsheet, but the dates are all in their patriotic calendar like this: 102/06/05 102/06/22 102/07/01 ... I need them in Gregorian format like this: ...
1
vote
3answers
794 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
1answer
838 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 ...
0
votes
0answers
133 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
57 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
7k 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
949 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
284 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
3k 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
557 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
197 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
479 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
526 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
441 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
248 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 ...
2
votes
1answer
5k 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 ...
0
votes
3answers
2k 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
532 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
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. ...
0
votes
1answer
283 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
830 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
74 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
501 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
245 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
1k 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?
21
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
858 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 ...