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

learn more… | top users | synonyms

5
votes
1answer
72 views

Historical reason why date's %h and %b format codes produce the same output?

Is there a historical reason why date's %h and %b format codes produce the same output? $ echo $(date +\%h) Mar $ echo $(date +\%b) Mar Other redundancies exist in date format codes as well, but ...
-2
votes
0answers
11 views

date of birth, may be stored in dd/mm/yyyy format using java [on hold]

//how to declare this in java? date of birth, may be stored in dd/mm/yyyy //how to enter date dd/mm/yyyy and shows the day? for example 10/10/1987 was saturday thanks,
1
vote
2answers
4k 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
8k views

Change All User short date format in Windows 2008R2 using script

I have hundreds of users in Windows 2008 R2. How can i change these user's Regional setting's short date format to DD-MM-YYYY using script ? Thanks
0
votes
1answer
25 views

Return Date from Excel

I need to find the last date an SKU was updated please. There could be blanks or zeroes in the data so I need to exclude them.
1
vote
1answer
13 views

Auto - updated change date in Powerpoint

Is there a way to add date of the last slide change to powerpoint? The date as offered by powerpoint can be fixed or auto-updated, but this updates at each printig/opening. I would like it to update ...
-1
votes
0answers
17 views

Mac OS X Mavericks isn't showing month in calendar or time window

So I have tried almost everything I can think of besides just doing a clean install. I don't have a close backup without going back to December (my fault). I tried upgrading to El Capitan which ...
-1
votes
1answer
41 views

Windows 10 doesn't show date [duplicate]

My PC with Windows 10 doesn't show the date - refer to the picture. How to fix that?
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
28 views

When I enter a date it will only insert the sample date

I have tried entering the date by right click "insert date" and choosing mm/dd/yy when I hit enter the date appears as the sample date and I can't get the current date to appear.
0
votes
1answer
19 views

Excel - Multiplying daily values for each week

What I have: over 200 rows, each with three values, each for a unique day. Only values for workdays are listed, so sometimes there may be days or even whole weeks missing from the list because of ...
0
votes
0answers
38 views

Wrong date format in IE 11 but correct in Microsoft Edge

In IE 11 the date is shown as English US (04.26.2016) In Edge the date is shown as Icelandic (26.04.2016) I also changed the language options in IE 11 but that didn't help. Why are the browsers ...
12
votes
11answers
88k 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
3answers
39 views

Sort by `ls -l` Dates Without Using `ls`

I have a text file with a bunch of ls -l output, such as: -rw-r--r-- 1 root root 7554952082 Dec 15 22:11 /var/spool/stuff/Investigation/messages.tgz -rw-r--r-- 1 root root 4315 Mar 3 2015 ...
0
votes
1answer
14 views

CreationTime and LastWriteTime

My wife copy photos to a smartphone. The pictures are 20160403_145233.jpg are called, are the first of 2012/03/10 But The creation date is 04/14/2016, date of transfer. What she sorts the photos by ...
0
votes
1answer
18 views

Excel: conditional formatting with with complex function AND

I have a sheet that looks like this: So I have a list of documents to create, and I mark "1" on the column with the month in which I have created them. Now I've been asked to put "1" also as a ...
0
votes
1answer
29 views

Excel Pivot Table - How can I return a date in the row value?

I have raw data that includes hundreds of employees who have completed many different training courses and I am needing to insert a pivot table that shows the course name as the column labels, the ...
2
votes
3answers
36k 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?
0
votes
0answers
16 views

Count number of minutes in each hour of a period defined by start and finish times in excel

I have a big number of records in excel which have a start date/time and an end date/time Event name Started Ended Event1 25/3/2016 01:55:10 25/3/2016 06:15:50 ...
0
votes
0answers
33 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
1answer
11 views

List folders by date modified

Normally if I want to list everything in the folder by date modified I would type the expression datemodified:‎<16/03/2014 into the search bar at the top. This expression lists everything in that ...
0
votes
0answers
55 views

how do i filter by a rolling date range from a sql query

I am trying to filter a query by a date range, but a moving date range. I have heard (read on this site) that this can be handled in a formula in excel, but I couldn't really follow the formula that ...
5
votes
1answer
22 views

Add date watermark to jpg images

I am attempting to add a watermark to images that contains the date. I am not having any trouble putting text on images but as soon as I try and put a date I get unpredicted results. convert ...
3
votes
1answer
5k views

Importing specific date format to Excel from Microsoft SQL Server

I've already asked the question at: StackOverFlow and got sent to this place here. I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool. ...
1
vote
1answer
19 views

How can I complete a PDF form with Adobe Acrobat Pro so that I can use ISO 8601 (i.e., yyyy-mm-dd) to input date field?

How can I complete a PDF form with Adobe Acrobat Pro so that I can use ISO 8601 (i.e., yyyy-mm-dd) to input date field? By default, it's mm-dd-yyyy or mm-dd-yy: I use Adobe Acrobat Pro XI with ...
1
vote
1answer
60 views

Linux tar files within specific date range using filename date

I have files whose names begin with YYYYMMDD like the following: 20160221_143223_Report.csv 20160222_121223_Report.csv ... 20160229_141223_Report.csv 20160301_171223_Report.csv I want to ...
2
votes
0answers
131 views

Wrong installation date and size in Programs and Features

Nearly every fourth installed program in this list has an estimated size of 7,04GB. Also for some the date gets updated every day. The corresponding reg keys were all set to "0x0070caf9 (7391993)" ...
0
votes
2answers
33 views

How do I change date origin in libreoffice writer?

I am copying a chart from a Calc file to a Writer file. The Calc file has a date origin of 1904. When I copy the chart to the writer file, all the dates get shifted because the origin is (I suppose) ...
0
votes
2answers
66 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 ...
0
votes
1answer
40 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)
7
votes
1answer
4k 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
1answer
59 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
893 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
703 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
42 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
2answers
32 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
30 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
3answers
101 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
48 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: ...
6
votes
8answers
39k 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
3answers
191 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
votes
1answer
369 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
34 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 ...
1
vote
1answer
316 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
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
225 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
192 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 ...
1
vote
3answers
83 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
79 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 ...