The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 views

How to find out when an audio disc (CD) has been written/burned?

Is there a way/tool to determine the date and time when an audio disc (CD) has been written/burned? I am aware of How to find out when a disc (DVD) has been written/burned? but the accepted solution ...
0
votes
0answers
4 views

Date input in PHP is not saving the DATE selected in SQL Server 2008 R2 using CodeIgniter [migrated]

Greeting folks! Why does the date I selected is not saving in my SQL Server 2008 R2? However, the date saved in my DB is 1970-01-01. Can somebody tell me why or what's the problem? or is it on my ...
1
vote
1answer
16 views

Batch adjust / increment file date by an offset?

Suppose I have a folder of 100 files, and they have created/modified dates that are wrong, because the real-time-clock in the device that wrote them was wrong. I want to add the same offset to the ...
-2
votes
1answer
33 views

How to calculate monthly sum from the entries for each date in Excel?

I have colums for my workout logging: Date Running (minutes) Pushups Pullups Crunches and the rest of my workout entries. I insert my achievements each day. How can I script Excel to ...
0
votes
3answers
40 views

How to calculate the first occurrence of a given weekday in the next year in Excel?

I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the ...
-1
votes
1answer
38 views

Calculating Dates Backwards in Excel

I am trying to calculate 6 Fridays before a certain date, as well as 4 Fridays before a certain date, in order to establish deadlines for several departmental responsibilities. I would like the dates ...
13
votes
2answers
14k views

how to add a day to date in bash?

For example, I have date: 4 August 1993 and I want to add 348 days to it, how can I do it in bash?
1
vote
1answer
167 views

Excel TEXT function does not work properly

Let say I have the following values in the cells A1 : `=Now()` which displays 17.03.2014 13:45 A2 : 12.03.2014 Both are in date format and I have the function in another cells like this: B1 : ...
0
votes
1answer
71 views

Change All User short date format in Windows 2008R2 using script

I have hundreds of users in Windows 2008 R2. How can i change these user's Regional setting's short date format to DD-MM-YYYY using script ? Thanks
1
vote
1answer
86 views

Timezone setting in linux

I'm setting timezone GMT+6 in my linux machine by copying zoneinfo file to /etc/localtime but date command showing time UTCtime-6, can any one explain me this behaviour? I'm assuming date command ...
4
votes
6answers
15k 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 ...
0
votes
1answer
19 views

Excel opens asking for a date

I am creating a spreadsheet that needs to ask the user to input a date upon opening the workbook. The answer field needs to include a valid date range that goes back 13 months. Once a valid date ...
4
votes
11answers
17k 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 ...
5
votes
5answers
18k views

Change year in many date fields in excel?

So I've noticed in a worksheet I have many dates that are four years off, no doubt because of improper copy/paste from earlier question. Is there an easy way to convert a bunch of dates I select to a ...
0
votes
0answers
36 views

My sent email is contains the current computer date for no reason

Everytime I tried to send an email through Gmail in Firefox, at the end of the e-mail, appears the current date in the format of YYYY-MM-DD HH:MM Timezone First Name Last Name Email Address: So ...
3
votes
1answer
77 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 ...
0
votes
3answers
948 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
800 views

My windows explorer shows future dates for date modified

My windows explorer shows dates like tomorrow, next week and even later this year when grouping my files with date modified. What is going on?
1
vote
1answer
51 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 ...
14
votes
7answers
20k views

Windows 7 - display date using small icons

I recently upgraded to Windows 7 and need the date displayed with the time. This works, but only if I use large icons in the taskbar settings which is quite ugly. Any ideas how to display the time ...
0
votes
1answer
45 views

Mac OSX Numbers - Convert text to datetime

I am using Numbers on a Mac. I have a CSV file which contains numerous dates in the format MM/DD/YYYY. I need to convert these dates into datetime format for insertion into a MySQL table. How do I ...
-1
votes
3answers
93 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; ...
0
votes
2answers
2k 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
1answer
32 views

Excel 2010 - Calculate dates and return a 0 if it is the current date or date passed

I need to calculate days between today and the 'Last day to offer' and have Excel return a 0 if today is the last day to offer or if the date has passed; otherwise it should return the number of days ...
0
votes
3answers
62 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 ...
5
votes
4answers
5k 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?
1
vote
3answers
1k 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
vote
4answers
255 views

Converting text date into standard date format in Excel 2010

I've got an Excel 2010 spreadsheet that has a large number of dates for the year 2014 entered in the following format: Thursday 24th July that I need to convert into standard date time format (the end ...
13
votes
8answers
41k views

Windows 7 System Tray Date Display Not Appearing

I'm using Windows 7 RC and for some reason, the date won't show at all on my system tray. It used to for a while, but one day it just stopped (I didn't even notice it until someone pointed it out). ...
0
votes
0answers
33 views

Filter excel pivot table using date range

I am exporting an MS Project file into an Excel spreadsheet. I would like to be able to pivot my tasks by assignee, by task etc. I would like to be able to filter the tasks such that if the start ...
0
votes
2answers
67 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 ...
-2
votes
1answer
93 views

How to change a date inside an EXE file?

I have come to a conclusion that every time this program goes beyound 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
1answer
80 views

Excel macros date format worldwide

On a Mac Mountain Lion, US locales, I'm working on a Spreadsheet with macros like TEXT(TODAY(), "yyyy-mm-dd")&" is the date" The problem is that the sheet is also used on computers set with ...
1
vote
1answer
30 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
0answers
41 views

Excel 2013 does not allow cell containing a date to be changed

I have a row containing 12 dates, formatted MMM-YY, ranging from Jan-13 through Dec-13. When I click on the cell containing Jan-13, "Jan-13" (without the quotes) shows up in the edit bar above the ...
2
votes
2answers
4k 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 ...
0
votes
1answer
59 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 ...
1
vote
1answer
862 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?
1
vote
1answer
176 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 ...
0
votes
1answer
106 views

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)? Excel File Origin I have an Excel file that was originally a CSV file. At this time I don't have ...
0
votes
1answer
2k 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 ...
0
votes
1answer
366 views

Excel - Convert currency as text to numbers

I frequently copy and paste HTML tables into Excel to do quick aggregate operations (e.g. sums, averages, etc). In this example, PayPal, their HTML table contains text values like A | B ...
0
votes
2answers
53 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
209 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). ...
1
vote
2answers
168 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.
1
vote
2answers
1k views

How do I list files modified on or before particular date?

Using linux commands , is there way to list files which are created an hour (or particular date) before ?.
5
votes
2answers
12k 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?
0
votes
0answers
24 views

Filtering dates from different sheets

I have an excel workbook which consists of around 200 separate worksheets. Column A on each sheet is a date column. I need some vba which will give the names of all sheets that have a stipulated date ...
0
votes
1answer
105 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
2answers
76 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 ...