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

learn more… | top users | synonyms

1
vote
2answers
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
1
vote
0answers
8 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
2answers
42 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
0answers
21 views

Linux Server wrong time [closed]

Few Linux servers fail to update/sync time from/with ntp server and go one hour ahead, what's wrong with them? (Timezone is set correctly. The problem is with offset which increases over time until "...
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.
15
votes
5answers
20k views

Store the output of date and watch command to a file

I am a newbie to linux and I am trying to watch a command and try to log it into a file. I tried watch -t -n 10 "(date '+TIME:%H:%M:%S' ; ps aux | grep "pattern" | wc -l)" >> logfile and am ...
0
votes
1answer
3k views

System date change tracking in windows xp

I wanted to track when system time was changed in a PC.By looking at event viewer for event id 520 i will get it. But when i changed date manually in windows and look at event viewer i found 4 entries ...
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
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
20 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. ...
12
votes
12answers
104k 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
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
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";} ...
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" ...
2
votes
3answers
3k views

unable to use datediff function in apache openoffice calc

I am unable to get a result by using this command =DATEDIFF('dd', '2007-08-01', '2007-09-01') in apache openoffice calc. Even using two columns of dates and using the formula =DATEDIFF('dd','A2','B2')...
1
vote
3answers
58 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?
5
votes
1answer
74 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
2answers
5k 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?
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
18 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
60 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
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 - 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
85 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 ...
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
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
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 ...
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 ...
2
votes
3answers
37k 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
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 ...
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
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
77 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 -...
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
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
210 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
76 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
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)
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
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
vote
2answers
708 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
45 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
34 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 ...