Questions tagged [date]
For questions concerned with obtaining, manipulating or presenting the calendar date.
37
questions
65
votes
22
answers
789k
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 ...
23
votes
9
answers
143k
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 Day=%...
31
votes
9
answers
58k
views
Windows 7 - display date using small icons
I recently upgraded to Windows 7 and need the date displayed with the time. This works, but only if I use large icons in the taskbar settings which is quite ugly.
How do I display the time and date ...
8
votes
2
answers
13k
views
How can I get the date in a locale independent format in a batch file?
I'm trying to read a file that contains a date in the filename.
The problem is when the date format is US in the system: mm/dd/yyyy it does not working .
For this format : dd/mm/yyyy it works as ...
0
votes
1
answer
303
views
Linux: date cmd doesn't accept its own output string as input string?
$ date
Mi 14. Jun 09:54:58 CEST 2017
$ date -d "Mi 14. Jun 09:54:58 CEST 2017" +%s
date: invalid date ‘Mi 14. Jun 09:54:58 CEST 2017’
Why wouldn't the date command accept its own output string as ...
0
votes
2
answers
477
views
How do I tell Windows to adjust the time even if it's waaay off?
Apparently Windows 10 gets confused about what time it is - I'm pretty sure that my BIOS clock isn't getting reset, as it's just fine under Linux, and the date portion is fine it's just the hours that ...
15
votes
5
answers
11k
views
Is there any software or hardware which lets you stop, slow down, speed up or even reverse time?
Obviously I'm talking about time in terms of the PC clock rather than real time.
We were testing an application we've developed at work by setting the clock forward and back to simulate different ...
5
votes
1
answer
11k
views
Timezone setting in Linux
I'm setting timezone GMT+6 on my Linux machine by copying the zoneinfo file to /etc/localtime, but the date command is showing the time UTCtime-6. What is the reason for this behaviour?
I'm assuming ...
4
votes
2
answers
31k
views
How can I display a UTC date time value in the user's local time zone in Excel?
I have a spreadsheet with date/time values in UTC that I would like to be displayed to users in their time zone, e.g. the same spreadsheet containing UTC date/time values is provided to users in ...
4
votes
2
answers
634
views
Excel - forecast future date based on average number of days between a variable number of dates in the past
I have anywhere from two to six dates for events in the past and based on the average spread from each one to the other, I need to predict when the next event will occur.
From the screenshot, I ...
2
votes
0
answers
430
views
Set system time after Suspend
After waking up (after Power Off/Log Out > Suspend) the system time is wrong (either in the future or past).
$ systemctl restart systemd-timesyncd.service
makes it right again. Is there a way to ...
1
vote
3
answers
40k
views
Do not refresh date in IF Statement using TODAY()
I'm using Excel 2010 and I would like to get the current date using an IF statement that does NOT refresh each time the worksheet is opened. Is there a way to do this with IF or is there another ...
1
vote
2
answers
232
views
Complex Cell Formula
I want a formula that will return a date that depends on the date in another cell, but modified by the day of the week of the date in that cell.
If cell A1 has a date value that is a Sunday, Monday, ...
-1
votes
1
answer
13k
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 hournum=%...
-1
votes
1
answer
5k
views
How to add a month to an Excel date value? [duplicate]
I tried to google for a while but it seems to have no straight forward way to do this math.
For example, we have the date at B2 12/31/2012 and need to add 2 months to it and store value in B4. What ...
35
votes
8
answers
56k
views
Timezone conversion by command line
I know about http://www.timeanddate.com/worldclock/converter.html
I can't figure out how to query http://www.google.com in a sane natural format like "5pm BST in PST".
Or do I have to write such an ...
29
votes
3
answers
28k
views
How do I pipe output to date -d "value"?
I have a date like 2014-01-30 05:04:27 GMT, and if I run date -d "2014-01-30 05:04:27 GMT", the output is in my server's timezone (Thu Jan 30 16:04:27 EST 2014).
With the use of grep and cut,...
28
votes
3
answers
7k
views
Why are Excel weekdays wrong for 1900?
This question is based on the observations of AdamV in his answer on How do I get the day name into a cell in Excel?
When A1 has the value 2009-08-01, then:
=WEEKDAY(A1) will obtain 7
=TEXT(7, "...
11
votes
2
answers
21k
views
Is there any way to view dates of changes to Windows registry keys/values?
Is there any sort of date tracking that is done or viewable in the Windows registry, such as seeing the date when X key was created, or Y key was modified, similar to how file systems track?
I'm ...
11
votes
2
answers
11k
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 ...
10
votes
4
answers
15k
views
Wrong week number in Outlook
I was stupefied to see this screen in Outlook 2013:
As per ISO 8601:
The ISO 8601 definition for week 01 is the week with the Gregorian
year's first Thursday in it. The following definitions ...
6
votes
1
answer
5k
views
How can I fix a date that changes by 4 years and 1 day when pasted between Excel workbooks
In Excel dates are represented internally by a floating point number where the integer part is the number of days since "some date" and the fractional part is how far into that day (hence the time). ...
5
votes
3
answers
12k
views
Taskbar/system tray suddenly changed to 3 rows. How do I get my one row taskbar back in Windows 7?
I have Windows 7. My task bar( system tray in lower right corner) is unlocked but it will not let me drag it back into one row.
The problem is the clock: the first row is suddenly time(2:30PM), ...
4
votes
0
answers
3k
views
How to find out when an audio disc (CD) has been written/burned?
Is there a way/tool to determine the date and time when an audio disc (CD) has been written/burned?
I am aware of How to find out when a disc (DVD) has been written/burned? but the accepted solution ...
4
votes
1
answer
7k
views
Setting file creation date in Mac OS X
I need a script to set the creation date to the modification date for a bunch of files created by my sound recorder - any way to do this? Running Mac OS X 10.4.11
4
votes
0
answers
2k
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)" ...
4
votes
3
answers
37k
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?
3
votes
3
answers
686
views
Display day of week in Taskbar without impacting Excel
With Windows 8.1, I would like the current day of the week (or abbreviation thereof) to show in my taskbar along with or alongside time and date, without ramifications for Excel and, preferably, no ...
2
votes
1
answer
6k
views
How do I write a batch script to generate folders for each month, day and year?
How do I write a batch script to generate folders for each month, day and year based on user input?
2
votes
1
answer
4k
views
How to disable day of the week in extended taskbar on Windows 10
So I have small taskbar buttons and I want to have date and hour on the taskbar. I unlock my taskbar and I extend it just a little but it doesn't show hour and date first but skips to date, hour and ...
2
votes
3
answers
4k
views
How to get date value in commandline
I need to do a command that takes yesterday date and builds it into a file path like this:
copy "Something 2010-12-06\*.zip" "d:\Copy\"
where 2010-12-6 is yesterday's date in format yyyy-mm-dd.
...
1
vote
2
answers
2k
views
Finding the MAX value over a range but if one row is blank, the value for MAX must be blank
I want to do a MAX value for the latest date in my data for the "Actual" column, but, say that one cell has no date, I want the MAX (in yellow) to be blank too. Any help would be appreciated!...
1
vote
3
answers
45k
views
How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?
My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format.
I tried to format using Excel custom date format and built-in ...
1
vote
2
answers
11k
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
1
answer
3k
views
How to bulk rename files in a directory using the Date column
I've got a list of a few hundred files that I need renamed by appending a modified version of the Date column to the front of the file name.
The tricky part is the use of the Date column. I've tried ...
0
votes
1
answer
1k
views
Make a date field static after mail merge using Word
I often have to deal with mail merging (at least once a month).
I use a dynamic field for inserting the Date, the problem is the dynamic field remains such even after mail merging when you save the ...
0
votes
1
answer
135
views
How to delete days with no data?
I have the flow data for 49 years for 15 min interval. I've used pivot table to get the daily average value of flow.
After copy-pasting from pivot table and using filter to remove the blank flow ...