The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
5 views

How do I get the access date for millions of files on an LSF file system without using stat?

How do I get the access date for millions of files on an LSF file system without using stat? I want to avoid using stat, because it's apparently not a good thing to query about metadata this way. None ...
1
vote
1answer
31 views

Converting date Jan-12 2015 10:51AM to Date format for sharepoint use

I have a date that imports into excel from an external source as Jan-12 2015 10:51AM, but is not a friendly date format for copyinging into sharepoint 2013 datasheet. How do I convert this in excel so ...
0
votes
1answer
32 views

How to use conditional formatting to highlight specific days of the week AND time periods?

This answer regarding formatting on date time information Excel 2010 Conditional Formatting - TIME is a very, very technical answer that, in truth, I don't really understand! Hey-ho, I can deal with ...
7
votes
6answers
28k 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 ...
-1
votes
1answer
35 views

How can I tell when my computer was manufactured.?

I want to install a operating system and my computer must be manufactured between 2006 and 2014. How can I tell when it was manufactured?
4
votes
12answers
29k 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 ...
1
vote
0answers
15 views

LC_date like option for excel sheet (possible in libre office)

Windows 8.1, office 2013, english interface - danish region. When working in excel I often paste dates from another application. These dates are in the form Januar 2013. When pasting, it seems excel ...
0
votes
2answers
41 views

Changing date on Ubuntu without sudo privilages

I am trying to automate a time change on Ubuntu 10.04 with a bash script using the date command. The script works, but it requires sudo privileges, however, the user who will execute the script does ...
0
votes
2answers
63 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 ...
2
votes
0answers
28 views

Date types management mismatch (2-digits year) - on copy/paste user action

I find a strange inconsistency when copying-pasting dates on MS Excel, when they have a 2 digits year. I work on a machine Windows 7 Enterprise 64 bit and my Excel is a 2010 version. PROBLEM ...
-1
votes
1answer
19 views

Creation date of zip file

Is there any way how can I get creation date of zip file which is stored on server? Or even better when the file was uploaded on server? I do not have access to the server disk, I can only download ...
0
votes
0answers
13 views

How to elegantly log working times by file changes

I would like to get to know some (windows) program, or some scripting lines, that could help me to get a chronological list (in the form of a text file) of file changes, on a drive or directory, ...
1
vote
4answers
888 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 ...
0
votes
3answers
46 views

How do I get the fiscal year to start on a specific date each year in Excel?

I used the formula listed here to generate a fiscal year based on the current month. I have an odd requirement where she wants the fiscal year to start on 6/20. For example, any dates ranging from ...
0
votes
1answer
74 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 dc3.mydomaain.local this works fine and updates the host with the ...
1
vote
1answer
25 views

Make folders' last modified date correspond to last modified date of its child folders/files

I am working with FileZilla to locate the last modified files of my website. I thought the last modified date of a parent folder will correspond to the latest last modified date of its children files ...
0
votes
0answers
162 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
21 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 ...
1
vote
1answer
1k 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
2answers
22k views

How to change the date of Linux to UTC/GMT +1?

I need to change the date of my system. I'm running a Linux CentOS 5.6. # date +%Z UTC # date Thu Oct 6 11:42:45 UTC 2011 How do I change the hour to be UTC/GMT +1?
2
votes
4answers
151 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
vote
1answer
17 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
19 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 ...
26
votes
7answers
163k views

How to set current time on Linux?

Why is the output of the following commands different? root@vmi2115:/var# hwclock Sun 26 Jun 2011 01:21:38 PM CEST -0.273230 seconds root@vmi2495:/var# date Sun Jun 26 15:21:39 CEST 2011 ...
0
votes
1answer
69 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
20 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 ...
2
votes
3answers
2k views

How to get date value in commandline

I need to do a command that takes yesterday date and builds it into a file path like this: copy "Something 2010-12-06\*.zip" "d:\Copy\" where 2010-12-6 is yesterday's date in format yyyy-mm-dd. ...
14
votes
10answers
47k 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). ...
4
votes
2answers
2k 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
2answers
120 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
845 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
40 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 ...
1
vote
2answers
1k 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 ...
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
41 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 ...
4
votes
7answers
21k 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
2answers
278 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!
18
votes
7answers
26k 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 ...
4
votes
4answers
457 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
50 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 ...
10
votes
3answers
10k views

How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?

I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08, but Excel automatically converts the date format to 4/8/2012. I tried scrolling through the different types of ...
3
votes
1answer
1k 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
0answers
65 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 ...
-3
votes
2answers
502 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 ...
3
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
vote
2answers
99 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
155 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 ...
4
votes
1answer
6k views

Put date into backup .tar.gz filename

I'd like to run a simple tar command to backup my website directory. It will run through cron, but I want to be able to put the time at which the backup was made as the filename. I don't really mind ...
0
votes
3answers
146 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 ...
1
vote
0answers
165 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 ...