Questions tagged [date]
For questions concerned with obtaining, manipulating or presenting the calendar date.
511
questions
2
votes
2
answers
3k
views
Excel, use conditional formatting to highlight dates in current fiscal year?
In Excel 2016, I'm trying to use conditional formatting to highlight dates in a current fiscal year, but I can't figure out how to write the formula correctly. The fiscal year goes from 10/01/19 to 09/...
1
vote
2
answers
3k
views
Excel date format changes with different regional settings (2020-08-01 to 2020.08.01)
I searched most of the posts, but there is no solution to my problem.
This is what I tried using Excel 365 with English Windows Machine:
And this is what I get when I open the file with Excel 365 on ...
0
votes
1
answer
73
views
Creating "semi-regular" lists of dates in Excel
Consider the Excel power user club of Wheatland, Wyoming. The club meets evey Thursday, plus every second Monday. So there are, alternating, weeks with two, and weeks with only one meeting. Let us ...
0
votes
1
answer
231
views
Dates in between the Date Range - SQL Server
I have a table which holds:
PlaceID, STARTDATE, ENDDATE, OCCUPANCY
100, Jan 1, Jan 10, Occupied
100, Jan 15, Jan 20, Occupied
100, Jan 11, Jan 14, Empty
100, Jan 21, Jan 31, Empty
200, Jan ...
0
votes
1
answer
489
views
Excel PivotTable Date Grouping in 24-hr Center
I am attempting to analyze data of agents working in my company that runs 24/7. I was going to construct a pivot table to show the daily operations of each individual. This fit most of my needs ...
0
votes
1
answer
243
views
Command 'date +%W' does not return week 00
Manual page for date(1) says:
%W week number of year, with Monday as first day of week (00..53)
I assumed there exists a week number 00, and I handle such week in my program, but once I decided to ...
0
votes
0
answers
30
views
Create Appointment Calendar from Master Spreadsheet
We have an old doc that struggles with Excel. We track his appointments and other pt specific information in Excel. However, the entire Excel spreadsheet is too complicated for him to deal with. I'...
2
votes
1
answer
949
views
Why does Excel now require a slash for dates and how do I change it back so it does not?
I used to be able to type a date without any separators, ie 062509 and Excel would recognize it and return the date in whichever date format I selected, such as June 25, 2009 or 06/25/2009. Now Excel ...
0
votes
1
answer
3k
views
Can not display date as MMM-YY in Power Pivot chart
Currently I am working on an excel data model which have several Power Pivot Chart in it. I need to make the date format of the axis become MMM-YY (ex: Mar-19) but can not.
Current chart format with ...
0
votes
3
answers
355
views
How to find which column contains the first occurance of a number in a single row? (Excel)
I have an Excel sheet with over 100 dates as column names and hundreds of locations as row names.
There are numbers (could be any number) somewhere in each row that indicate that an event will occur ...
0
votes
1
answer
69
views
Plotting of timeseries (ISO8601) in LibreCalc
I have a CSV file with:
2020-30-05T23:23 10.000
2020-31-05T09:46 20.000
2020-31-05T13:45 30.000
2020-31-05T19:10 40.000
2020-31-05T23:22 50.000
2020-01-06T09:45 60.000
2020-01-06T17:...
0
votes
0
answers
30
views
Why is the Date column sometimes the Date Taken column, but 12 hours ahead?
In an effort to find an answer to my other question, I came across this unusual behavior.
Sometimes the Date column is a copy of the Date Taken column, down to the minute, but exactly 12 hours ahead. ...
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 ...
1
vote
1
answer
302
views
Date format to string in ddmmyyyy
So I am working on an existing workbook so I cannot change the layout unfortunately. In the first sheet, a function automatically returns today's date in the "yyyymmdd" format. On another sheet, that ...
3
votes
2
answers
14k
views
How can I place a date in dd/mm/yyyy format into an Excel cell with VBA?
I want to fill a cell in a worksheet with the date as string and I want it to be in the dd/mm/yyyy format. I use the following code but it keeps showing as mm/dd/yyyy. I'm not sure what I am doing ...
0
votes
1
answer
174
views
How should this datetime format be interpreted? "20190328012019.000000+120"
20190328012019.000000+120
That's the weird timestamp outputted by WMIC commands on Windows. I assume that 2019 is the year, 03 is the month and 28 is the day, and that 01 is the hour, 20 the minute ...
0
votes
1
answer
51
views
How to include more dates on my x axis
I’m having issue to include additional dates on my x axis.
Usually I’d select data, edit my horizontal axis label to include more dates. (2nd pic) But it’s not showing up on my graph. (1st pic) I also ...
1
vote
1
answer
3k
views
Excel not properly comparing dates, despite same cell format
I have two date rows. Both are formatted as dates. When I do a logic test to see whether the two dates, excel is not recognizing them as the same.
Here is a screenshot of the cells:
This is to ...
0
votes
1
answer
414
views
command date not respecting timezone
I'm in git-bash on Windows 10 :
~$ locale
LANG=C
LC_CTYPE="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_COLLATE="C"
LC_MONETARY="C"
LC_MESSAGES="C"
LC_ALL=
~$ date --version
date (GNU coreutils)...
1
vote
1
answer
39
views
Excel count numbers, with taking day of today in account
I have an Excel sheet that looks like this:
In the column "Total" I have the total amount of minutes that need to be executed.
In the days after the "Todo" column I have the number of minutes that ...
0
votes
0
answers
193
views
Date command not working properly for America/Bogota timezone
On RHEL 7.2 I have set the timezone to "America/Bogota (COT)" With that, if I execute date command it works fine, But if I try to get the UTC timestamp for given timestamp where the timezone is Bogota ...
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 ...
0
votes
1
answer
239
views
Counting the occurence of active durations by month and into a graph
Lets assume I currently have a spreadsheet that holds the dates of members at a crossfit gym and the duration of their memberships.
Date Started Date Ended Member Name
11/27/2019 12/19/2019 ...
0
votes
2
answers
2k
views
How to add fractional year to date in Excel?
Is there a way to add a fractional year to a date in Excel? I have tried something like =date(2000 + 1.2, 1, 1) but the result is 1/1/2001 rather than the expected approximate of 3/14/2001.
0
votes
0
answers
321
views
Windows 10 - "Sort by Date" but with files on top?
I've noticed that for some reason, anything I unzip uses some other Modified by Date that is far older than when the folder was unzipped on my PC, that makes it very annoying to go through my files. ...
0
votes
1
answer
404
views
How to autogenerate a date in a libre calc
I think this is easy but I am not finding solutions online. I have recurring bills and would simply like date values to change every month in their respective cells.
For example if cell A2 due date ...
2
votes
1
answer
1k
views
Calculate Gregorian Julian Date from Regular Date in Excel
I am trying to get a Julian Date from a regular date (mm/dd/yyyy) in Excel. There seems to be two kinds of Julian date calculation.
One is described Here..
The other is somehow related to Gregorian ...
0
votes
1
answer
131
views
Date math not giving expected result
I've seen several examples (including this post) and it seems simple enough but I don't quite get what I'm doing wrong (I know that post is for linux but I tried w/ the date command on a linux machine ...
0
votes
1
answer
726
views
set date +90 days in bash script
I have a bash script to get days from AD since password was created. I need it to tell me the expiration date, which is last set date + 90 days
#!/bin/bash
pass="$(ldapsearch -Y GSSAPI -Q -H ldap:///...
1
vote
0
answers
60
views
Received PDF “scan” of alleged e-mail with Sent time later than Received? Fake?
I recently received a bulk PDF file version of important legal documents / correspondence etc. required for court case. I've found a number of suspicious looking, possibly altered docs, etc. After a ...
1
vote
2
answers
729
views
Debian 9 vs Debian 10 different date output, the same locale, the same timezone
Could you please advise what is the reason of this difference? How can I change the output of Debian 10 to display 24 hours format with date command (with no additional parameters).
Debian 9
date ...
1
vote
2
answers
864
views
GNU/Linux Date Command Ordinal Suffix
The PHP date function offers the ability to add an ordinal suffix for the day of the month, such as 'st', 'nd', 'rd', etc. Is it possible to achieve the same thing with the date command in Linux?
1
vote
2
answers
743
views
How to convert start/end date to week duration in Excel?
I was wondiring how to convert Start Date and End Date to week duration assuming that the results are always prime numbers?
For example:
2
votes
1
answer
149
views
Excel default date when dd/mm entered
In Excel when i enter a date into a blank cell (General format) as, say 7/15, the cell changes it's format to "Custom: m-ddd". How can i make doing this default to the standard default date "*3/14/12"...
4
votes
2
answers
13k
views
Are Excel table headers always converted to text?
I am trying to get table headers containing dates to auto-fill properly, so that they increase by one day between columns.
Unfortunately, Excel seems to treat table headers as text regardless of the ...
2
votes
1
answer
493
views
I know how to fix Excel dates stored as text, but *why* does it happen?
The question of how to handle dates stored as text in Excel is common, and so are the answers. But can anyone explain why it happens -- and in particular, whose "fault" is it?
I use a tool that can ...
1
vote
1
answer
6k
views
phpmyadmin Default transformations for DateFormat does not change date format
I am using phpmyadmin 4.8.3 running on Ubuntu 16.04.6 LTS with Mysql 14.14 Distrib 5.6.42. I wanted to change the default format yyyy-mm-dd to dd-mm-yyyy. Based on my research I can do this using "...
5
votes
4
answers
2k
views
No solution for Thunderbird date format
I run Linux Mint 19.2 and Thunderbird 60.8.0 (July 2019). I am trying to change the UI to display the dates in a reasonable date format called ISO 8601, and for that I tried setting LC_TIME=en_DK.UTF-...
0
votes
1
answer
1k
views
Excel formula to calculate date based on 2 cells and how to copy to other cells?
Novice excel user here. Here is a simplified version of my spreadsheet:
start date end date eday duration
-21 4
12 0
begindate = "03/...
0
votes
0
answers
28
views
Macro is not effective with Date Format Column?
I have written this macro to UNDO any Filters Before saving the spreadsheet.
Here is my code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If ActiveSheet.FilterMode ...
0
votes
2
answers
753
views
convert Date to Julian day in Excel
How to calculate the fourth column based on the first three columns in Excel?
Date cell to Julian day
for example:
year month day **Julian day**
2000 1 1 1
2000 1 2 ...
0
votes
1
answer
355
views
Excel Date calculation
I need to calculate prorated days for real estate closings automatically for the tax prorations. I have everything figured out except I have to manually enter the prorated date. For example, house ...
1
vote
1
answer
369
views
Why does time spontaneously change in debian?
Debian 8.
Host system, no virtualization.
Time synchronization systems are disabled. ntp, rdate, sdwdate are not installed.
# timedatectl
Local time: Thu 2019-08-22 14:02:05 +03
Universal time: Thu ...
0
votes
1
answer
579
views
converting time in excel and/or adding +12 hours
I have this time in excel 2019-08-04T06:48:45.000Z
It is in GMT time, how do I convert it to +12 hours?
So what I want is 2019-08-04T18:48:45.000Z.
That's an easier one(just have to change the hour) ...
1
vote
1
answer
123
views
Date formatting only available as root
I have a really weird behavior on both my RaspberryPi 3 and OrangePi 3 after upgrading them to Debian 10.
The date command works but I can't set my own formatting with a non-elevated user:
baprx@...
0
votes
1
answer
40
views
How to convert dates by working backwards from end of month?
I'd like to convert dates to weeks of month, but I'd like the weeks to be counted back to front, kind of. So if there are 5 weeks in a month, I'd like the last 7 days to be week 5, last 8 to 14 days ...
1
vote
1
answer
630
views
MS Excel - How to model my data in order to produce a chart broken down into product and month (year on year)?
I have one single date column in my raw data. The dates range across 2018 and 2018. I have multiple products and each row represents a sale transaction. There are multiple transactions per product.
...
0
votes
2
answers
96
views
How to manipulate dates?
How can I change a date in an Excel file
to eliminate the day and be left with only the month and year?
E.g., convert 4/4/2019 to April-2019?
I am aware that I can change the format, but if I do so, ...
1
vote
0
answers
34
views
ntp + ntp loose synchronize each time in 5:00 morning
we have a very strange behavior
we have 12 Linux redhat machines - redhat 7.x
two of these VM servers are loosing the time synchronize each day at 5:00 in the morning
after we restart the chronyd , ...
0
votes
1
answer
29
views
Debian GNU\Linux Time Differences
i'm trying to find out why my linux have this difference in times:
cmd1: date
out1: Sun 14 Jul 2019 12:45:59 AM CDT
cmd2: hwclock
out2: 2019-07-14 00:46:48.389904-04:00
cmd3: timedatectl
out3:
...