For questions concerned with obtaining, manipulating or presenting the calendar date.

learn more… | top users | synonyms

0
votes
0answers
27 views

Why won't `date` accept it's own default output?

On my system right now by default date outputs: $ date Fri 29 Jan 22:04:26 GMT 2016 However if I try to feed dates of this format back into date it results in "invalid date": $ date -d "$(date)" ...
0
votes
1answer
18 views

Can the MS Word Date Picker force the user to enter a date?

Seems you can type anything you want into a date picker field. Is there a way to force the user to enter a valid date in the proper format (dd-mm-yyyy vs mm-dd-yyyy)
1
vote
1answer
34 views

Adjust creation date/time of files already copied?

I recently replaced my laptop's hard-disk with a bigger capacity SSD. Windows was re-installed from scratch and then I copied my data to the SSD by putting the old hard-disk in an external USB ...
7
votes
1answer
883 views

Pull a user-defined season from a date?

So I want to pull a season from a date. I have a seasons table and it goes a little like this. Jan = Low (low/mid/high = season) feb = low mar = low apr = mid may = mid jun = high jul = high aug = ...
-1
votes
1answer
30 views

Put date modified field of the MP3 file into it's ID3 tag

Is there a quick way to do what title says? I tried MP3Tag but I don't think it's possible at all. Google search didn't help either.
0
votes
1answer
38 views

How to have Excel recognize date in format MMM YYYY (e.g. Mar 2015)?

I have a system that has outputs reports to Excel but Excel does not recognize the format as a date--"Mar 2015" to be "Mar-15". This makes pivoting the data hard because the date column is sorted ...
1
vote
2answers
26 views

extract in same column cell with different format

I need to extract value in same column that have different format (date and text) as showed below: 09/02/80 23/12/73 ANA ANA 11/03/83 11/03/83 07/07/34 How could obtain from one column two ...
-1
votes
1answer
26 views

Linux find files that differ from a given date

i would like to search for file that has not a give date. for example i want to find in my server all file created before 2015-12-01 o after any suggestion ? thanks luca refer also to Command to ...
0
votes
4answers
63 views

Easy way to fill colum with sequential dates in Excel

I want to fill column A with sequential dates. Like this: 01/12/2015 02/12/2015 03/12/2015 This is easy for a small number of rows. Is there an easy way to do this for six months worth without ...
0
votes
0answers
30 views

Google: reverse search image by date?

Each time I try to combine the two I fail, yet this would be great to find the original version of an image. For time range: ...
2
votes
1answer
66 views

BIOS date/time reset

After 5 years of heavy use, I noticed that my laptops fan is constantly on, so I decided to change the thermal paste of the cpu. Everything went fine except for some strange reason my laptop keeps on ...
0
votes
3answers
120 views

Motherboard makes screeching/beeping sound after replacing CPU cooler

Added on Nov 9: I put the old cooler back in place, as per Keltari's suggestion, and while the sound is much less pronounced, upon close inspection I can still hear it. It may have been there all ...
0
votes
1answer
12 views

Display Date using small icons script how to add year?

I found ArtOfWarfare's script on this thread Windows 7 - display date using small icons I think it's great however it's missing one thing, the year. Is there anyway to add the year to the script and ...
0
votes
1answer
24 views

Date range for jobs & conversions SUMPRODUCT

I'm trying to run a report within Excel that shows the total number of jobs completed by employees within a date range and also a count of the number of conversions per employee within the same date ...
0
votes
1answer
55 views

How do I change time format in Windows 10 Windows Update scheduler?

My Date & time format are set correctly as far as I can surmise, I live in Finland, but prefer English as my OS language, yet, parts of Windows 10 UI seem to follow the 10PM/AM style instead of ...
1
vote
0answers
28 views

linux - set date offset from BIOS date

Linux can use BIOS clock in UTC or local time mode so it can add certain offset to BIOS time at OS level. Is it possible to do the same for date? I mean lets say I'd have 1999 year set in BIOS and ...
3
votes
2answers
147 views

How to make date YYYY-MM-DD (ISO-8601) the default in Excel?

In Excel how can I make the ISO8601 date format, yyyy-mm-dd, the default? Windows locale is English(CA) or English(US). We're using Excel 2013, though a generic answer for as many versions as possible ...
0
votes
0answers
17 views

Is there any way to set up an iTunes smart playlist that depends on the real time?

I love Christmas music! In November through January. I want my iTunes Smart Playlist to include my Christmas music (Already stored in a separate Smart Playlist (here's my filter)) from November ...
1
vote
1answer
105 views

Linux date command not working

I can't seem to get the terminal command 'date' working. Here is an example of the commands I gave in terminal: $ date Wed Oct 7 17:17:38 EDT 2015 $ sudo date --set="20151007 18:17:00" Wed Oct 7 ...
1
vote
1answer
168 views

MP4 video - Editing Creation Date and Other Metadate

I wish to find out if it is possible to edit the creation date and time of an MP4 video file. I have attempted to do so using ffmpeg with the syntax listed below ffmpeg -y -i "22.mp4" -c copy ...
0
votes
0answers
18 views

Office Word template date fields

In a Word template I am using date fields, just like this: Document valid from {CREATEDATE} until {CREATEDATE + 15 days}. It should render, for example: "Document valid from 06/10/2015 until ...
4
votes
2answers
132 views

Manipulating datestamp string consistently with date format %Y%m%d

I need create log files that are essentially date stamps with prefix yp_ and suffix .log, and a manipulated day number: $ touch yp_$(echo "$(date +%Y%m%d)-10" | /usr/bin/bc -l).log $ ls ...
0
votes
1answer
38 views

Get excel to undo its helpful date conversion

When importing and manipulating data in excel, certain coding systems (like CAS numbers) are always a problem because numbers like 8000-01-7 can become 7th of january 8000. There is usually (but not ...
-1
votes
1answer
300 views

Windows 10 clock shows misordered day and weekday

I use the calendar a lot for my job. Since I have Windows 10, I've been lost with the calendar because it shows days in a different position than the correct date. Let's say today is Monday 7, it ...
1
vote
3answers
57 views

How to insert the date as quarter in Word 2010?

In Excel the quarter can be calculated by using a formula. How about in Word 2010? Is there a way to insert the current quarter such as "Q1-2008"? It should be an auto-updated field such as the ...
0
votes
1answer
67 views

How do I get the day of the week back on my taskbar on windows 10?

How do I get the day of the week back under the date on the taskbar? It used to be there automatically on windows 7 when I moved the taskbar left and increased the width. Not on Windows 10 though. Any ...
1
vote
1answer
49 views

Excel, Differences within Day for Multiple Dates

Im currently facing a problem trying to find variations in a Database as follows: > Date | Hour | Place 1 | Place 2 | Place 3 ... Place K (about 50) ...
1
vote
0answers
75 views

Solaris + date + what is the same equivalent for Solaris [closed]

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
26 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
3answers
102 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 ...
0
votes
1answer
46 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 ...
0
votes
1answer
197 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 ...
1
vote
2answers
96 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
1k 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
102 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
223 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
2answers
768 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
29 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
76 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 ...
0
votes
0answers
124 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
50 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
111 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
62 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
vote
1answer
88 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 ...
-1
votes
2answers
7k 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
1answer
27 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 ...
1
vote
2answers
3k 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
127 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
855 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
520 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 ...