Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
7 views

NTPD not updating time date on CENTOS

I have set up ntpd on CENTOS, I am trying to get it to pull time from a Windows domain contoller if i run the command: ntpdate dc1.mydomaain.local this works fine and updates the host with the ...
0
votes
1answer
9 views

Open Office Calc - Stop date autoformatting

When I paste raw data into calc some of it converts to a date automatically (it is not date data, it simply contains a hyphen). This data is then lost because if i turn it back into text I get an ...
-3
votes
2answers
50 views

Last time a file has been copied [closed]

Is there anyway to find out the last time a file has been copied from a USB - fat32 - to a Windows XP machine? I have only access the usb drive .
1
vote
1answer
14 views

Date command - adjusting the date works on my mac but NOT the server's shell

On my mac I can ask for the date in threes days time: Josephs-MacBook-Pro-3$date -v 3d Fri 3 Oct 2014 08:54:26 BST Josephs-MacBook-Pro-3$ but when I try that on my dreamhost server: ...
0
votes
0answers
16 views

Robocopy files only with a certain date

I am looking to copy files from x: to z: only if the destination file has a date changed of 9/23/2014. If the destination file has an older or newer date, don't touch it. X is my backup and Z is the ...
0
votes
1answer
38 views

How to use DATEVALUE with diffent locale setting without changing system settings

I have an Excel column that uses US date format, i.e. MM/DD/YYYY, but is a text column. I need to convert it to the date column for which I'd normally use the DATEVALUE() function. However, because my ...
1
vote
1answer
17 views

How do I have a Date format show in a Formula that is looking up that cell?

I have a formula: ="('"&A6&"','"&B6&"','"&C6&"','"&D6&"','"&E6&"')," And B6 is a date and formatted as dd/mm/yyyy (have tried all forms though) so the ...
0
votes
3answers
145 views

Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what. I have a spreadsheet, exported from our exchange server, that contains a column ...
1
vote
1answer
35 views

Create a non standard weekly date range autofill in excel

I am working on a monthly spreadsheet of our daily takings. I need one line for a sunday, monday and tuesday but two lines for wednesday, thursday, friday and saturday. I can't seem to hit the magic ...
0
votes
1answer
41 views

Format dates so they are split across two lines

See the dates above? I'd like to format them so they are split over two lines, as illustrated below (Note: the Oct 13 is a mistake; it should have been split as well). In other words, between the ...
0
votes
1answer
30 views

Looking for a formula(s) that will return the next date (higher than the starting date) from a row of dates, then the next date from that one

Worksheet 1 lists all of the "legs" flown by our aircraft. The leg or legs for each day would then go to Worksheet 2 for Day 1, Worksheet 3 for Day 2, and so on. Legs are listed in columns starting ...
0
votes
2answers
88 views

Comparing dates in excel

How do I compare date in the following format with today's date and work out the no. of days in between? 31.12.2016 Formula: A1-Today() doesn't seem to work. It returns #VALUE!
1
vote
2answers
791 views

How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?

My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format. I tried to format using Excel custom date format and built-in ...
4
votes
4answers
418 views

How to use “date” to print tomorrow's day of the week

On CentOS 6 Linux I use date +%a in several cronjobs and scripts to generate logfile names like myprog-Tue.txt and this works well for me since many years. But now for one program I need to delete ...
-1
votes
3answers
48 views

Excel Formula to match dates

This may sound really simple but I need a formula that checks if one column's date is the same as another, and if so put 'true' or '1' or something. I tried =IF(H2=G2, "True", "False") but it does not ...
0
votes
0answers
57 views

Excel Command Button to change Cell Focus

I have a multi sheet workbook I use for staff rostering. Each sheet is for for a 6 month period (eg Sheet 1 is Jan-Jun 2014, Sheet 2 is Jul-Dec 2014) going back to 2010. I have the dates along Row 3 ...
1
vote
2answers
85 views

How to set date for a specific program?

after june 2008 the game gears of war is giving error and not running. so when I want to play it, I need to change date about 6 years. so I'm curious is there anyway to set the time for a single ...
2
votes
1answer
113 views

How do I convert dates from Open Office format to MS Excel format

I am trying to save a file in Libre Office as an excel file but Excel sees the data displays it as a negative number using a series of ###### symbols. I believe the problem is to do with the two ...
1
vote
2answers
92 views

Excel 2010: Calculate full months between dates

I have dates in two columns and I would need to calculate amount of full months between two dates. I export the spreadsheet from SAP ERP in .xls format but opening with Excel 2010. DATEDIF function ...
0
votes
3answers
134 views

Ask for date on boot (challenge)

Issue An old laptop computer with XP loses date every time it boots. It has no more battery pack so it has to be plugged permanently in to wall. What I already tried Replaced the little button ...
0
votes
1answer
75 views

Return day number in year from date in Excel

I am trying to show the date in an adjacent cell as the number of days in the year. Jan 1 would be 1, Feb 1 would be 32, Dec 31 would be 365. Also the reverse, how many days are left in the year. Jan ...
0
votes
1answer
171 views

hardware clock is set but date command is displayed wrong date and time

I am setting date with settimeofday function my hardware clock is set perfectly but when i execute date command it shows me wrong date and time. but if i reboot the system than it show me proper ...
0
votes
0answers
7 views

Move all files in directory to date-time based structure [duplicate]

I am hoping someone here can help me with (hopefully) a simple task... I have a folder (/img/) with thousands of pictures in, and I need to move them into a date-time based folder structure based on ...
0
votes
1answer
59 views

Convoluted Date Lookup

I found this, which is pretty close, but I don't know VB, so I'm trying to do this with a vanilla formula. First worksheet has a series of tables of unemployment rate: 1 per US state. Each table ...
0
votes
1answer
47 views

getting todo.sh to sort due items first, then by priority

How can I get todo.sh to put items that are due: today first, then after that sort the normal way (A-Z priority then everything else)? There's this solution, but then you lose A-Z priority and have ...
3
votes
2answers
271 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 ...
1
vote
0answers
133 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 ...
2
votes
1answer
192 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
164 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
166 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 ...
-3
votes
1answer
229 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 ...
3
votes
2answers
1k 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 : ...
1
vote
1answer
2k 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
28 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
42 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
991 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 ...
3
votes
2answers
445 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
4answers
592 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
944 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 ...
1
vote
1answer
82 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
850 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
141 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
191 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
246 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
359 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
252 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
32 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
44 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
70 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
2k 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 ...