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

learn more… | top users | synonyms

0
votes
2answers
25 views

Convert YYYY-DD-MM HH:MM:SS to Days

I've extracted data from a power grid website and the time stamp corresponding to each power value is in the format YYYY-DD-MM HH:MM:SS on Excel. I need to convert this to days but am struggling. The ...
5
votes
1answer
14k views

What excel formula can I use to calculate the 2nd Monday of a given month?

What excel formula can I use to calculate the second Monday of a given month? You can assume I have a cell containing the first day of the month to work with. In the interests of other users, can ...
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)" ...
1
vote
2answers
3k 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
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
7k 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
1answer
3k 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 ...
1
vote
2answers
3k views

Convert Day of the Year in Excel?

How can I convert Day of the Year to a mm/dd format in Excel? Date of the Year: e.g. 1= Jan 1, 177 = June 27. For example, how do I convert "177" to 6/27?
1
vote
1answer
35 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
885 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
vote
2answers
674 views

Excel macro date parser cannot handle single-digit days

From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function: Function GetDate(strInput As String) As Date ...
-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
39 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
27 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
64 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 ...
10
votes
7answers
48k 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 ...
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: ...
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 ...
8
votes
9answers
60k 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 ...
6
votes
8answers
35k 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 ...
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
121 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 ...
1
vote
2answers
3k 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
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 ...
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 ...
-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
0answers
29 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
151 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 ...
1
vote
1answer
171 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 ...
5
votes
2answers
8k 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 ...
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
110 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 ...
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
134 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
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
2answers
4k views

How to override date format in regional and language options?

In Windows XP, it's not possible to display the date format in DD/MM/YYYY, because it wasn't available in the regional and language options. The following image will illustrate my problem. So ...
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
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
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
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
103 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 ...
39
votes
8answers
230k 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
44k 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
867 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
12k 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
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 ...