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

learn more… | top users | synonyms

7
votes
1answer
4k views

Wrong date created for files in Windows when copying files, if the file has already existed

I'm having a problem when copying files (or creating new files) on Windows 7. If I copy a file, I expect the date created to be correct, but sometimes it's not. Usually it works, but here is an ...
4
votes
2answers
3k views

How do I pipe output to date -d “value”?

I have a date like "2014-01-30 05:04:27 GMT", and if I run date -d "2014-01-30 05:04:27 GMT", the output is in my server's timezone ("Thu Jan 30 16:04:27 EST 2014"). With the use of grep and cut, I ...
2
votes
1answer
4k views

Timezone setting in Linux

I'm setting timezone GMT+6 on my Linux machine by copying the zoneinfo file to /etc/localtime, but the date command is showing the time UTCtime-6. What is the reason for this behaviour? I'm assuming ...
0
votes
2answers
542 views

Script to copy text including today's date into clipboard

I'd like to know if its possible in Windows for a script (or similar) to be written that will copy today's date and specific text into the clipboad, in the following format: dd/mm/yy - xx - xxx ...
-1
votes
3answers
555 views

convert text file column field with data dd.mm.yy to dd.mm.YYYY

How to format date for file content using linux command line tools? Input: aaa;1.70;ccc;20.01.13;zz;2013; uuu;2.70;lll;17.12.10;zz;2013; fff;3.70;nnn;31.01.98;zz;2013; auu;8.70;nuu;30.02.96;zz;2013; ...
-3
votes
2answers
2k views

How to change a date inside an EXE file?

I have come to a conclusion that every time this program goes beyond a date it gives me problem. So I would like to hack the exe and modify that date to avoid that problem. How to do that? It's a ...
1
vote
3answers
734 views

Make Excel recognise date in custom format

How can I make Excel recognize a text in the following format as a date and time? I have the following date in on cell: Tuesday, December 3, 2013 1:54:26 PM +01:00 And would like Excel to format the ...
1
vote
1answer
38 views

Search unix drive for file modified today

Is there a way I can search an entire unix drive for a file that was modified today? I realize this could take a while, but thats not an issue
0
votes
1answer
92 views

How to delete days with no data?

I have the flow data for 49 years for 15 min interval. I've used pivot table to get the daily average value of flow. After copy-pasting from pivot table and using filter to remove the blank flow ...
2
votes
2answers
976 views

Convert Month Number to Month Name

Is there a way to convert month number to name with a script? example: 2013-10-22 will become Oct 22 Thanks. BTW, I don't have the GNU date and my OS is AIX.
0
votes
1answer
315 views

create folder in powershell with previous date

I need a Powershell script which helps me to create a folder on destination with one previous date. Currently, I am using the code below. It helps me to create a folder on destination place with ...
2
votes
4answers
496 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 (referring to 7-Zip) native .7z format. Any Unix-based formats are ...
-1
votes
2answers
195 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
1
vote
1answer
177 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
120 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 ...
-1
votes
1answer
87 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
51 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
3k 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
4k 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 ...
1
vote
2answers
5k 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?
-1
votes
1answer
2k 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 ...
10
votes
4answers
8k 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
591 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
333 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
3k 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: 2013/...
1
vote
1answer
2k 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
247 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
62 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 04/...
0
votes
3answers
15k 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
3k 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
448 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
7k 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
2k 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 ...
3
votes
1answer
2k 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
3k 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
712 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
404 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 ...
5
votes
1answer
7k 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 ...
3
votes
1answer
5k 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
796 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
0
votes
1answer
386 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?
0
votes
1answer
100 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
837 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
503 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
3k 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
2k 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, "...
0
votes
1answer
443 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 values('",AQ2,"','"...
2
votes
2answers
7k 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
673 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 ...
6
votes
1answer
8k 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 ...