Questions tagged [date]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
65 views

Excel data extraction from column

I have data from hospital on patients deaths. The data is not arranged properly, the data is as in link below All the dates should in either column DOA (H Column) or DOD (I Column) or MB (J Column) ...
0
votes
1answer
20 views

How to get LibreOffice Calc to recognize dates in YYYY/MM/DD format?

I've been given a large tab-separated-values (TSV) text file that contains dates in the format YYYY/MM/DD. I tried copy and pasting the dates into LibreOffice Calc, but it didn't recognize the strings ...
0
votes
3answers
37 views

Excel data query

I'm trying to build out a budget monitoring spreadsheet. I want to pull sum of entries by category and based on the month. The data is in rows as follows and will grow each month as I download our ...
1
vote
1answer
32 views

Batch copy file with current date in file name

How to copy files from one directory to another, whose names contain current date, and so the names change daily. Example: File name: Test_14042021.txt Date today: 14/04/2021 // DDMMYYYY I tried this,...
1
vote
2answers
33 views

Need to simplify date entry in Excel spreadsheet

Every month I need to do a large spreadsheet for billing purposes. Among other columns I have one start date and another for end date, formatted as dd-mmm. To enter this date in the spreadsheet for ...
0
votes
2answers
29 views

Output of 'date +%a' always in system-language?

Does date +%a output always the weekday in the system language? No matter if in bash, sh or cronjob
1
vote
2answers
34 views

Excel won't recognize timestamp in format of “m/d/yyyy h:mm:ss AM/PM”

I have a column of timestamps (strings) formatted like so: This can be deduced to the following format: m/d/yyyy h:mm:ss AM/PM I'm trying to get them to be formatted into dates but Excel refuses for ...
0
votes
1answer
164 views

Plex view date history for Recently Played Movies

Plex has a list of your "Recently Played Movies" and "Recently Played Episodes": How can I view exactly when these movies were watched? Where can I see the play date of the Plex ...
0
votes
0answers
25 views

Change Date stamp to just Month and Year

I found this simple code to copy my files and paste them into a new folder and label it with the current MMDDYYYY. I'm trying now to get it to just give me the month and year (Ex. March 2021). @Echo ...
2
votes
2answers
130 views

Excel: find the nearest (to a reference one) date for each row

I'm not an Excel expert (not by far) and I've been having a hard time finding a solution for the following problem. I have a table that represents the scheduled day of shift (A) for each employee (B) ...
0
votes
1answer
36 views

Is there a way to automatically update a cell annually in excel?

Is there a way to update a cell automatically each year? For example, if the cell says 7, on the 31st August, it updates to 8 and so on? Thanks
0
votes
1answer
19 views

bash alias assignment in .bashrc for specific date command

I am trying to set an alias to show value of specific date command. When I set the alias, I get correct value, but also get "command not found..." Is there a way to set this without the ...
0
votes
0answers
35 views

How to manually change the Last Modified Date of a Windows file?

Windows explorer shows files and their Last Modified date, based on when they were last saved. Is there a way to manually edit that date in File Properties or through Command line, without naturally ...
1
vote
1answer
27 views

Win 10 Libraries option “Arrange by” won't display pictures from previous years?

It's simple as the title. On Windows 10, when I go to "Libraries", then to "Pictures" I can see folders that I included in a Library. When I open the folder, all the pictures are ...
0
votes
2answers
27 views

Return value based on date

I am running into an issue where I have various sectors that have been scored differently depending on the year. See example below: 2017 2018 2019 2020 ...
0
votes
3answers
34 views

Translate a string date in a numeric date

I have a date expressed by string, i.e. January 28, 2021 and I would like to express it in a mm/dd/yyyy date, so from "January 28, 2021" to "28/01/2021". My approach was to ...
0
votes
1answer
29 views

Show FULL WEEK-DAY NAME and FULL MONTH NAME in the Mac menu bar?

How can I show the FULL WEEK-DAY NAME and FULL MONTH NAME in the Mac menu bar? What should I change to make it possible?
0
votes
1answer
22 views

How to adjust the date format of an Excel column?

I have an Excel file with a date column. The first few entries look like this: I'd like to adjust the date format because the current format is not usable for an application I have in mind in QGIS, a ...
1
vote
3answers
43 views

How to get difference between two dates in random colums in Excel

I have a spreadsheet with about 8000 rows where I have a rowID and 11 columns populated with dates.  Each row has two dates and only two dates; i.e., the other nine columns are blank.  I want to ...
0
votes
1answer
24 views

Excel Formula > Selecting specific date of next month

I am trying to set up an automatic cell in Excel to show the same day of the Next Month based on the current month. In other words, if today is 11/20/2020, and I want to show the 13th day of the Next ...
1
vote
2answers
335 views

How do I filter a pivot table by a date range?

My client has a pivot table and he'd like to be able to filter by date range. The data has start dates and end dates: He'd like to be able to put in a filter for 10/1/2020 and have the pivot table ...
0
votes
1answer
48 views

Date, find out the number of days in a month

How can I use the date command to find out the number of days in the current and next month?
0
votes
1answer
68 views

bios version/date and windows installation date

i bought a laptop in july 2020 and the manufacture date that it has is march 2020. which i was happy about ,but the bios version date shows date of 2019 and someone told me that the windows ...
0
votes
1answer
124 views

Excel 365, convert text to date

It looks like this has been a question for a lot of people, but I've read over a lot of posts and I still can't figure this out. I have a column of dates that I copied from a Wikipedia chart. ...
0
votes
0answers
37 views

equation that will calculate the second Monday of the following month from a given date

I am seeking an equation that will calculate the second Monday of the following month from a given date, and I will adjust it to figure the same for 3rd, 6th, 9th, 11th, and 12th month. We do a mail-...
0
votes
0answers
9 views

COUNTIF occurrences of a posterior date (dynamically defined)

I need to count the occurences of «new inscriptions», per person, after a «cancellation date» different for each person. I have two excel 2013 speadsheets, one with all the inscriptions of each person ...
2
votes
2answers
296 views

Date reverts to current one in Windows Sandbox

I'm unable to change the current date in Windows Sandbox. I have disabled "Set time automatically" from the settings panel and I'm able to change the date, but 1 or 2 seconds later the date ...
0
votes
1answer
60 views

In Excel, fiscal year from date not working

In Excel 2016, I am trying to display the fiscal year in a column next to one with the date of an appointment. The dates are formatted as "short date". The fiscal year runs 10/01/2019 ...
2
votes
2answers
250 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/...
0
votes
0answers
10 views

Conditional 3 colour formatting on date calculations

I have a column of dates that I need to highlight in red when a date is 3 months overdue, yellow when 2 months overdue and green when 1 month or less from the due date. The final column is a simple ...
0
votes
0answers
11 views

awk help filtering a file for a time range and it is not capturing events that just occurred

I am building a bash script on mac os. I need to filter a log file for the lines within the last minute. So I either need to make one awk variable that contains all of the magical pass the date - 1-...
1
vote
2answers
298 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
1answer
62 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
1answer
25 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
1answer
105 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
1answer
56 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
0answers
16 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'...
1
vote
1answer
214 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
1answer
707 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
2answers
61 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
1answer
15 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
0answers
17 views

Formula to see if a date is before, during or after a specific date range

I am trying to see if a date is before, during or after a specific date range. For example: A1 16/01/2020 A2 01/01/19 B2 31/12/19 A3 01/01/20 B3 31/12/20 A4 01/01/21 B3 31/12/21 I need a formula ...
0
votes
0answers
27 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
1answer
1k 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
0answers
86 views

Why is 1st January 2020 formatted strangely in Excel Pivot Table?

I have a pivot table report containing data for 1st-7th January 2020 with date being used as row names. In the raw data, the dates in the data themselves are all formatted like 01-JAN-2020, 02-JAN-...
1
vote
1answer
49 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 ...
2
votes
2answers
4k 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
1answer
38 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
1answer
12 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
1answer
131 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 ...

1
2 3 4 5
9