Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [date]

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

0
votes
0answers
11 views

Cannot change Date formats on Excel [on hold]

Please see this thread. I am struggling to change the format of dates in a workbook. I cannot change them manually as there are too many items. I believe this is due to there being text in the column ...
0
votes
1answer
22 views

Can an email's date and time be falsified in Outlook?

I received a copy of an email that shows the date and time it was sent and to whom it was sent. I have reason to believe this is not a true email. Can it be proved that the date and time sent was ...
0
votes
1answer
25 views

Excel Calculate Date Differences between Orders Per Customer

I have a data-set with Account Names, Order IDs and Close Dates. I would like to see the number of days between orders, per customer, however Excel will not allow me to sort by date in my Pivot Table ...
0
votes
2answers
57 views

change 2017/2/3 to 2017/02/03

I have a column in Excel which shows date but not in date format, it is in text format and the values for those dates that have one character for the month or day don't contain a zero before them. E....
-2
votes
1answer
24 views

Excel 2013 Duplicate Value filter formula by date [closed]

So I am trying to count how many stores were audited in a quality tool. Around 8000 records. But there are duplicates and I only wish to count a store once. On top of that I need it for a date ...
1
vote
1answer
80 views

How do you round a time and date back to a previous day with a formula in excel?

I am trying to sum up hours for an employee worked in one shift. The employees I'm having a problem with are on night shift. The employees entries in excel are shown as individual tickets for work ...
0
votes
2answers
52 views

IExcel not comparing dates properly

I have a table with two dates in the following format: C1 Sep 21, 2017 10:22 AM C2 Sep 28, 2017 10:09 AM If I run the following if statement against them... =IF(M4<L4, "Fail", "Pass") ......
0
votes
1answer
60 views

How do you change the time of the Linux hardware (hwclock) clock to 24-hour format?

Currently, my hardware clock returns the date/time (hwclock --show) like this: Sat 28 Jul 2018 08:47:47 PM BST .659124 seconds And date returns: Sat Jul 28 21:23:13 BST 2018 I'd like to change ...
0
votes
0answers
51 views

Find number from date

I have the following problem: I have three data sets of numbers corresponding to different dates. Sometimes numbers at specific dates are not available at one data set but at the other. Therefore, I ...
2
votes
2answers
199 views

How to corrupt a file's date modified

We have an application that works with files. The application breaks whenever it encounters a file that has no date modified / date created (the field is literally blink in explorer and via get-...
2
votes
1answer
26 views

DDD, MMMM, YYYY, HH: MM nested script in word 2016 [closed]

I need to "nest" a script to include DDDD, MMMM, YYYY, \ HH:MM to portray like this; Saturday, March 15, 2018, 09:40 AM. I know how to write the date and the time separately but I would like to know ...
0
votes
0answers
51 views

Bios date changes after Windows 7 installation in Laptop

BIOS have correct date and time, but after Windows 7 installation system show date and time 6 year earlier (2012). When you set time in Windows suddenly bios date is set to 2024. Hardware is Acer ...
0
votes
1answer
28 views

Date as X-axis in Excel

Excel "latest" version (very recent at least, with the Ribbon interface, 2018). Fighting with dates to be used as X-axis labels in a chart. The data below came out of a Pivot table; when selecting ...
0
votes
1answer
41 views

Is there a way to spoof the date metadata on folders?

I have a collection of CreativeCommons music on a USB, that I used a digital TV to listen to, but its default media player is a bit limited. It offers only two list orders (data and alphabetic), which ...
2
votes
2answers
114 views

Multiple date formats in single column in excel

I have a csv file with a date column with dates in various forms as follows: dd-mm-yyyy yyyy-mm-dd yyyy-mm yyyy This irregular data is in a single columns. How do I convert all of them to the dd-...

15 30 50 per page