The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
18 views

MySQL Query to Select All and Convert Date [migrated]

How would I write a query in MySQL to select all and to convert 2 UNIX date columns to something readable, i.e. - from_unixtime(received_date) without needing to manually write out each of the other ...
0
votes
1answer
27 views

Picture SOrting by filename

I am looking for a program or something that can/will sort pictures I've taken into folders based on their filename. The pictures I take have their date as a file name. So I'm trying to have them all ...
29
votes
8answers
191k 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 ...
1
vote
2answers
30 views

DATEVALUE() gives different values for similar data

In one column, I have timestamps in the format Jun 10, 2015 11:36:51 AM So, to get the date from that column, I created another column and used the formula =DATEVALUE(CONCATENATE(MID(D2,5,2)," ...
12
votes
4answers
13k 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 ...
1
vote
2answers
2k 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
2answers
52 views

Day of the week and Time Graphing in Microsoft Excel

I have an Microsoft Excel document with two columns, date (mm/dd/yyyy) and time HH:MM(a/p). Each row represents an order (The day it was placed and the time it was placed). How can I graph this so ...
1
vote
1answer
25 views

LibreOffice: Autocomplete dates with month and year, no day

I'm using Libreoffice 4.4 and I want to drag down a column in format Month Year. For example: May 2015. I do not need days. I tried to drag down after doing this schema for 3 cells but it doesn't ...
-2
votes
1answer
104 views

How to calculate estimated moments with 8 hour work days

In my worksheet, I want to calculate estimated end times of processes taking into account workday timeframes. Assume working days of 8:00 - 17:00 and omit Saturday and Sunday. So, for example, when ...
1
vote
1answer
2k views

How to tell when RedHat was last updated

I have a RHEL 5 server and I want to know the last date in which it was updated. Is this technically feasible? If yes, how?
4
votes
1answer
7k views

How can I change the default date format?

When I paste a date into Excel 2010 in the format "2012-12-07 00:00:00.000" I'd like it to be displayed by default as "2012-12-07", but it is actually displayed as "00:00.0". I know I can work ...
4
votes
6answers
14k 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
2answers
125 views

Shell Script User Input Date Validation

How would I go about performing date validation on user input in a shell script? I want to notify the user if they enter the date in the wrong format. The correct format would be YYYYMMDD.
0
votes
1answer
23 views

EDATE minus 6 minus 6 is not same as -12

Is there some way to get 2014-06-30 minus 6 months to be 2013-12-31 rather than 2013-12-30 (i.e always end of month)
0
votes
1answer
28 views

How can I return a count of a specific criteria in a range of duplicated items?

I have two sheets (tabs) in an excel document, Sheet 1 and 2. As can be seen below Sheet 1 has 3 columns [1 row], and Sheet 2 has 2 columns [5 rows]. I am looking for a formula that will return the ...
1
vote
3answers
8k 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 ...
1
vote
2answers
1k views

Creating a column of working days in LibreOffice Calc

In LibreOffice Calc, I would like to create a column of working days, for example: [...] 2012-01-30 [Monday] 2012-01-27 2012-01-26 2012-01-25 2012-01-24 2012-01-23 [Monday] 2012-01-20 2012-01-19 ...
0
votes
1answer
3k 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
1answer
55 views

How to count months in intersection of two date ranges [closed]

I need to calculate the number of months in the intersection of two date ranges. For instance, in Column A I have start dates of employment 12/1/1998, 1/1/2003, 2/1/1995 and in column B I have ...
0
votes
0answers
33 views

Excel formula returning different results on different machines

For a piece of work I'm doing, I use a formula that calculates the difference between two dates for each row in the report that the system generates. Essentially, the software I'm using generates the ...
0
votes
1answer
31 views

Grab cell data and use in “IF” statement

Is it possible to grab a cell containing a date and paste that date in an "IF" statement containing text, similar to the below: ...
0
votes
2answers
47 views

Excel sees date/time value as text

I exported some data from a database as an excel file. One column contains date/time values in the following format: 2015-04-09 14:05:11.867 where the .867 indicate miliseconds. Excel reognizes ...
0
votes
1answer
41 views

LibreCalc Date-function returns wrong month

I have a spreadsheet with three columns for "Date", "Currency", and "Amount". Date Currency Amount Month 06.02.2015 EUR 188 March 30.01.2015 EUR 285 January I ...
0
votes
1answer
27 views

Excel 2011 plotting difference between logged sent-time / acknowledgment-time

I have an excel sheet which is a log containing the time that a message has been sent and the time that the corresponding acknowledgment for that message was received. It also contains the time ...
-1
votes
2answers
729 views

How to renew Google Chrome certificate (NET::ERR_CERT_DATE_INVALID)?

After installing a new Windows 7 laptop, my time was set a few hours in the future. Consequently, Google Mail (and other sites like stack overflow or tumblr) are displaying NET::ERR_CERT_DATE_INVALID ...
0
votes
0answers
19 views

Using ntp across LAN

I have 3 debian computers connected to a network switch across LAN without WAN access. I would like to manually set the date and time on one of the computers, then automatically sync the time to the ...
5
votes
2answers
1k views

How can I batch shift the creation date of files on OS X 10.6.8?

Please note that I am not asking how to change the creation date of a bunch of files to a given date. I want to shift the date by a given amount of time, for example 47732400 seconds. Can I ...
1
vote
2answers
380 views

I need todays date to auto fill in cell when data is entered into another cell

I would like to have cells C5-C39 auto fill the date when data is entered into cells B5-B39. I have tried to get it to work using =TODAY() but don't how structure the formula. Thanks.
1
vote
1answer
62 views

How do I create a batch file that will create a folder for each day of the month? [closed]

At the beginning of each month inside a directory, I need to create a folder for each day in that month (in the format of DDMMYYYY). I'd like to just run this script on the first day of each month ...
0
votes
1answer
119 views

Add Date-Time Stamp To Copied File using Windows Batch

I thought this would be simple but it seems more of a challenge than I thought. I want a file to be copied and pasted with a time stamp appended. I get the time stamp using this code: set ...
1
vote
3answers
149 views

Get DayName from Date in OpenOffice Calc?

I am having difficulty getting the day name from OpenOffice Calc. I am able to get the day Number representation from a date with the following WEEKDAY("2008-06-14"; 1) which returns 7 As we ...
0
votes
1answer
2k views

Formula to update cell based on user changing another cell's content

I want to know if there is a formula to update a cell in Excel with today's date when a user changes any value in the row that contains that cell OR when a user changes the value of 6 / 7 / 8 ...
6
votes
4answers
5k 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 ...
2
votes
1answer
102 views

How to change date format in multiple text files in powershell?

Hello I have around 5000 text files (TXT) in one directory.Files are comma delimited. What I'm trying to do is to change date format (it is stored in first column of each file) from M/d/yyyy to ...
1
vote
0answers
28 views

Run Query in Siebel on Modified due date

I want to run a query for open SRs by Modified due dates. I cannot find that field in normal query. Please help me out.
10
votes
3answers
23k 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
12 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
170 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
135 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 ...
9
votes
6answers
35k 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
81 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
35k 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
30 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
174 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
164 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
55 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
23 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
14 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
2k 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
116 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 ...