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

learn more… | top users | synonyms

0
votes
0answers
19 views

Printing date range in AIX [on hold]

I'm trying to print date range in AIX. I'm not able to use 'date' in AIX properly. I've tried some solutions suggested in Stack overflow. Nothing worked. Please find the error and code below and I can'...
1
vote
0answers
15 views

Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally ...
-1
votes
0answers
17 views

Locate original install date of company wide PCs (Not on domain)

I created a program in VB using WMI to pull data from each PC in our company. After doing so, I realized that the install dates were incorrect due to Windows 10 auto-installing on most of our PCs. ...
0
votes
0answers
12 views

Date being reset after I change, with ntpd disabled

Trying to set my RHEL server's date to one in the past for a test but it keeps being reset after about a minute of me changing it. I assumed it was ntp but I have since disabled the ntp service and it ...
0
votes
2answers
43 views

How to convert date from number format to String format?

My input is [10/04/16 01:02:03 BST].How can I convert to Apr 10 16 01:02:03? And I dont want to replace / to-.
0
votes
1answer
24 views

W10 computer office 3 min ahead of time, other PCs are ok

How can I solve that I am the only W10 computer in the room that shows a 3-4 min delay (vs http://www.time.gov/, mobiles and the rest of PCs). It is not a configuration problem, even when I ...
0
votes
3answers
22 views

How can I change the date format in MS Word 2016 to show only hours and minutes when mailmerging with an Excel file?

I'm trying to mail merge a MS Word letter with a MS Excel file which contains dates and times as well as other fields. I'm trying to put together for calling people to interviews at different times. ...
0
votes
1answer
34 views

Evaluation error in Match function

Can someone please tell me how this could possibly result in an error??? I don't know about you, but that looks like an exact match to me...
0
votes
0answers
21 views

Comparing date in google spreadsheet

I am trying to compare dates in a column to the current date using the script below but it gives me undefined status var toDay = new Date(); if (row[8] = toDay) {Department == "CRM";} ...
1
vote
2answers
37 views

sql - year day to day/month conversion

suppose I have the following table +-----------+-------------+ | DAY | LEAP YEAR | +-----------+-------------+ | 7 | true | | 167 | false | | 43 | true ...
0
votes
0answers
13 views

Date settings only last 30 minutes

I need to update the date for a Accesspro 4 access control. It uses busybox 13.4. I´ve configured the date via different ways #date -s "2016-06-13 14:00:00" or #date +%Y%d%m -s "2016-06-13 14:00:00" ...
1
vote
3answers
60 views

Batch script (cmd) resulting in DD-MM-YYYY_weekday format

I need to use date /t command and convert the date format to DD-MM-YYYY_weekday with all the "-" and "_" as listed I can't find an answer on my question. Could you please help me?
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
20 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
1answer
61 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?
0
votes
1answer
20 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
93 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 ...
0
votes
1answer
15 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
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
20 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 ...
1
vote
3answers
45 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 /var/...
0
votes
1answer
43 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 ...
0
votes
0answers
18 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 ...
1
vote
1answer
16 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
82 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
28 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 -...
5
votes
1answer
75 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 ...
1
vote
1answer
22 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
96 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
217 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
43 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
77 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
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)" ...
0
votes
1answer
54 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
79 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
900 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
48 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
35 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
125 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
55 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: http://google.com/#q=search+string&tbm=isch&tbs=cdr%3A1%2Ccd_min%...
0
votes
3answers
211 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
0answers
35 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 ...
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
309 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 18:...
1
vote
1answer
360 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 21/10/...
4
votes
2answers
210 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 yp_20150912....
-1
votes
1answer
385 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
105 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 ...