The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
12 views

Display day of week in Taskbar without impacting Excel

With Windows 8.1, I would like the current day of the week (or abbreviation thereof) to show in my taskbar along with or alongside time and date, without ramifications for Excel and, preferably, no ...
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
20 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 ...
-1
votes
1answer
39 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 ...
0
votes
3answers
41 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 ...
-2
votes
1answer
36 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 ...
1
vote
1answer
172 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
89 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
0
votes
1answer
20 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 ...
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
85 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 ...
1
vote
1answer
53 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 ...
0
votes
1answer
48 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
vote
1answer
124 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 ...
1
vote
1answer
34 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 ...
1
vote
4answers
279 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 ...
0
votes
0answers
34 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
71 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
95 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; ...
-2
votes
1answer
99 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 ...
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 ...
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 ...
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 ...
0
votes
1answer
119 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 ...
1
vote
1answer
82 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 ...
0
votes
1answer
405 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 ...
1
vote
2answers
173 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
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
108 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 ...
0
votes
1answer
89 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
2k 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
69 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
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
94 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
88 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
64 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
728 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
53 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
37 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
601 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
0answers
67 views

Excel 2013 CSV converting to Dates

I have searched high and low for this answer. Everything I have read says to format the field to 'text' and that simply does not work. Ok, when saving my excel sheet in .csv, it decides to convert my ...
0
votes
0answers
38 views

Format issue with dates over the 13 in excel

I have the following problem. I'm not able to modify all dates older than the day 13. For example: With the date 07/01/2013 11:20:00 I am able to change the format. To 07/01/2013 11:20 a.m. But with ...
0
votes
3answers
969 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 ...
2
votes
1answer
627 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
156 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
265 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 ...
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 ...