The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
11 views

Solaris + date + what is the same equivalent for Solaris

on Linux the syntax for date with seconds is: date +%s 1438587288 from MAN PAGE - %s seconds since 1970-01-01 00:00:00 UTC what is the same equivalent for Solaris?
0
votes
1answer
18 views

solaris + how to verify if file isn’t update more than XX min

how to verify if file isn’t update more than 55 min? For example, the file IOstatDisk2.log not update since 18:00 And now the current time is 19:00 solaris1a:/var/tmp ROOT # ls -ltr IOstatDisk2.log ...
0
votes
0answers
10 views

Format date from text string in php

Situation 'Commencement Date' input I want to format the users inputted date to DD/MM/YYYY however the input must stay text if the user inputs ASAP Forexample ASAP => ASAP 08/08/2015 => 08/08/2015 ...
0
votes
3answers
38 views

Excel: Check if date has a day

I have cells with dates in Excel. Some dates have dd-mm-yy (e.g. 20-01-15), others just have mm-yy (e.g. 01-15). I want to determine which cells have a day specified by the user. As far as I can ...
32
votes
8answers
196k 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 ...
5
votes
12answers
36k 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 ...
0
votes
1answer
174 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 ...
11
votes
2answers
11k views

In Windows 7, how to show day name in system tray clock?

Without installing third-party software, how do I display the day in the clock in the lower-right system tray clock in Windows 7. For example: "Tuesday" (in addition to normal time and date ...
0
votes
1answer
23 views

Converting non-numeric date to individual month,day, year components, and combining into one cell as datevalue

I have a date that Excel does not see as a value, I parsed out the month, day, year components into three separate cells, and converted to values, and now need to combine them in one cell to be seen ...
3
votes
2answers
414 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
3answers
9k 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
0answers
11 views

Batch file to change system date on start up?

Cmos battery dead with wrong time/date cant fix it at the moment In the time being I want a batch file to change the system date and time to current as a start up task But if the date/time is wrong ...
13
votes
5answers
14k 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
1answer
28 views

date and time can't be changed windows 8.1

I need to change my date to something wrong for some reasons. I get no errors and there are no other problems and I can see the change in the left-bottom corner, but after just after a few seconds or ...
0
votes
1answer
35 views

Picture SOrting by filename [closed]

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 ...
1
vote
2answers
38 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)," ...
0
votes
2answers
131 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
37 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
117 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 ...
5
votes
6answers
19k 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
230 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
25 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
30 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
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
56 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
40 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
34 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
52 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
45 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
32 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
1k 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
20 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
644 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
75 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 ...
1
vote
3answers
164 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
119 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
194 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
165 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
36k 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
109 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?