Questions tagged [date]
For questions concerned with obtaining, manipulating or presenting the calendar date.
493
questions
1
vote
2
answers
36
views
How to copy files changed in last 20 days to a different location recusively
I found a code here (on this site) which allows copying of files changed in last 20 days. My issue is that I have a folder with many subfolders and some subfolders could be 8 or more levels deeps. I ...
1
vote
1
answer
29
views
How to tell which files are new or have been modified between calls of a script
I want to call a shell script regularly, and in it I need to process the files present in a directory tree that are new or that have been modified since the previous call of the script.
My 1st thought ...
- 170
0
votes
1
answer
47
views
How to calculate DocVariable In MS Word using dates
I have DocVariables in MS Word working fine, for example this gives me a date:
{ DOCVARIABLE LEGALDOCEFD \* MERGEFORMAT }
But I need to fill out an expire date, for example:
{ DOCVARIABLE ...
0
votes
0
answers
30
views
How can I preserve creation dates when packing/unpacking 7z files?
From my tests, when unpacking files from a .7z archive, 7-zip preserves the "last modified" date but sets the creation date to the time of the file extraction (unpacking).
Is there any way ...
- 155
1
vote
0
answers
26
views
adding date and time while converting m2ts to mp4 using ffmpeg?
I have many m2ts video files which were created by Sony camcorder. Because they are my family history, I want to see the date and time when I play them. But no players have such functions. I think I ...
- 11
2
votes
1
answer
64
views
Windows 11 changed Finnish date format to not include weekday, now my batch scripts won't work
I have this script that relies on getting the current day of the week from the command line..
if "%date:~0,2%"=="ma" set "weekday=true" & set "hangday=false"...
- 210
0
votes
0
answers
15
views
Formatting of dates (Days / Months) on Windows 10 / 11
I know that we have a certain amount of control in the operating system to adjust the way dates are displayed.
This issue relates to how some of the locales display:
Days
Months
For some locales it ...
- 155
1
vote
1
answer
43
views
Update cell value based on dates in other columns
I would like to:
Update a cell (A2) with a status. That could be a standardised list, for example: "Sent to Customer", "Customer Replied", "Task Closed".
There are three ...
- 1,552
0
votes
2
answers
47
views
How do i convert a date, stored as text with time, as "DD/MM/YYYY"
Please can you help, I have a report, with a fixed output of "Dec 15 2022 17:00:00" as the date for each line of date; however, I need to add a column to change this data to "DD/MM/YYYY&...
0
votes
2
answers
25
views
Sort out whose who are still working by date
I have an Excel file with 4 columns: Name, Staff_No, Date_Joined, Date_Left.
My boss wants to know those who are still working.
The output should look: Name, Staff_No, Date_Joined.
Any idea for the ...
- 1
0
votes
0
answers
62
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
- 1
0
votes
1
answer
31
views
How to stop excel from displaying 3-letter months
I am running Excel (Microsoft® Excel® for Microsoft 365 MSO Version 2211) on Windows 10.
Whenever I enter a date without a year into a cell, Excel displays the month as 3-letter abbreviations instead ...
- 177
0
votes
1
answer
74
views
Auto Update Date & Timestamp in a specific cell irrespective of any data range (With or Without VBA)?
Would anyone be able to help me with this issue?
I have data based on the categories (as per spent) in specific columns & cells, i.e.,
C4:C25, F4:F25, I4:I10.
However, I want the "Updated ...
0
votes
1
answer
37
views
Excel: Custom format of date that excel cannot notice
My problem looks like this:
Dec 8, 2022, 8:35:04 AM
I need to let excel see this format as. I tried date to columns option, it didn't work. I did it in like 10 steps. Can it be done any simpler by ...
0
votes
0
answers
11
views
Dlookup() function not functioning with date field in forms
I have created a customer data table and Dlookup that has values in a form of another invoice table. Through Dlookup function, all the fields are working and copied through Dlookup function except ...
2
votes
1
answer
267
views
Using a date in an Excel function does not work when the date comes from another cell
I have the following problem: using a date as a condition in an MS Excel function works fine, as long as I write the date in the function code, such as ">1.1.2022".
But when I write the ...
- 21
0
votes
0
answers
61
views
How do I correctly format the unknown date which is probably wrong in excel?
I have this above data set in which i am pretty sure the signup_date column is wrongly formatted as it doesn't make sense for the years to be in future as the data belongs to years 2019-2021. How do i ...
- 1
2
votes
0
answers
373
views
Firefox date format
I want to display dates in FireFox as DD.MM.YYYY, despite the fact that I'm using the en-us version of FireFox, which causes the date to be in MM/DD/YYYY format. I would like to continue using the en-...
- 233
0
votes
0
answers
60
views
How can I group photos by dates when browsing a folder via Adobe Bridge?
When browsing a folder via Adobe Bridge, one can sort photos by creation or modification dates. How can I visually group photos by dates? Eg, group of photos taken yesterday, group of photos taken two ...
- 19.9k
1
vote
2
answers
183
views
How to combine day, week, year into a single date
I have a large dataset with three date columns: year (e.g., 2020) month (e.g., 8 for August) and week (1,2,3 or 4). I'm struggling to find a way to combine them into one date in Excel. I can only find ...
2
votes
3
answers
184
views
Parse dates like "20220928" in Excel
I have an input column which contains an id + datetime:
id12345!20220926_100911
My goal is to get the date and I have already successfully extracted the date into text with a formula involving LEFT, ...
- 1,554
0
votes
0
answers
42
views
Custom Date Locale in Excell
Does anyone know where the date locales are stored in Excel? I would love to be able to create a custom format (a copy of the gregorian calendar, but with different month and weekday names).
0
votes
0
answers
28
views
How do I limit data validation to certain dates given an arbitrary week number in Excel?
I'm trying to find the Monday and Friday of any week in a preselected month to limit the dates of records to that specific week as a Poka-Yoke practice on a troubling report.
As context: Workers have ...
0
votes
1
answer
481
views
Group Outlook tasks by due-date categories: "Today," "Tomorrow," "This Week," "Next Week," etc
I use Outlook's Task "peek" to organize my to-do list. When I let Outlook "Automatically group [tasks] according to arrangement," as in this picture—
—it groups them by the ...
- 136
0
votes
0
answers
243
views
Dynamic filter in PivotTable based on the system date
I have a pivot table in Excel 2016.
In the PivotTable, I want to create a filter on the data's YEAR column so that only records where the YEAR is between this year and this year + 9 are used in the ...
- 137
0
votes
1
answer
149
views
Excel VLOOKUP or INDEX MATCH with Multiple Criteria and Date Range
I have been struggling to solve this for a couple of days.
I tried some VLOOKUP or INDEX MATCH with multiple criteria but it doesn't work.
=VLOOKUP(TABLE 2B2&C2,TABLE 1 B:D,3,TRUE)
I have table 1, ...
- 3
0
votes
0
answers
1k
views
Stop Excel from re-interpreting date format on re-opening CSV
I have many large datasets that I am saving in .csv format, the input date values are in Julian format, but the final date format I want is dd/mm/yyyy hh:mm:ss. This part is simple, I just apply a ...
Thomas
-1
votes
2
answers
91
views
Hijri to Gregorian not getting converted in Excel 365
I have a calendar in Hijri dates. I convert them to gregorian by typing the corresponding cell reference like =+A2. Then I format the value to gregorian date through Format Cell command. This has ...
- 1
2
votes
0
answers
226
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 ...
0
votes
2
answers
493
views
Excel date function - unknown day or month
Not sure if what I want is possible (I'd imagine it isn't as Excel likes things to be correct!), but, I have a list of items, and the date to/from they were in use. In some cases, the day and/or month ...
- 1
0
votes
3
answers
6k
views
Don't show 1900 on blank date
I have a spreadsheet that converts the date in one cell to a year in another. I want to pull the formula down so that it automatically shows the date in columns A and B if there is a date in column C; ...
0
votes
2
answers
116
views
Does date -s command ignore NTP service?
I am synchronizing time using GPSD and Chrony. However, if the time is manually changed with date -s while the NTP service is active, synchronization is not possible again.
If time is changed with ...
0
votes
3
answers
252
views
Date function in Debian is IST, how do I change the default timezone of date, all the timezones are correct CEST
I have a Raspberry Pi 4 without RTC.
I am using pisignage, a signage solution for the Pi. It's viewing a webpage with a time.
The pi is showing the wrong time because the date command on the pi is ...
- 1
0
votes
2
answers
338
views
How to add Epi Week aka MMWR Week column in Power BI
My dataset has a date column. I need to assign the correct Epi Week/MMWR Week to each row. I can't do it by hand because the dataset spans five years and has over 18,000 rows.
The Power Query function ...
- 230
0
votes
1
answer
45
views
Formula to calculate multiple dates in one cell
I have two columns, one with a date ex. Nov 10. In the second column bedside it I want to a formula to calculate a list of all dates at 1 week intervals for the month. Currently I am using this ...
0
votes
0
answers
71
views
Excel previously changed text to dates. How do I get it back to what I originally typed?
I have a large Excel (xlsx) spreadsheet full of various types of data. I had initially downloaded this data from Google Sheets. At some point (I'm not sure when), one of my columns of data that had ...
1
vote
1
answer
7k
views
Inserting Today's Date In A Cell If Other Cell Values Are Changed or Added [duplicate]
I have a spreadsheet with a column labeled, "Status Date," in a row with several other cells, some with other dates, some with just text, and others which evaluate whether a set of ...
1
vote
2
answers
76
views
I Need To Compare 4 Dates Against Today's Date To Get A Yes Or No Result
I have 4 cells on the same row that are either blank or contain a date (YYYY-MM-DD), which I need to compare to today's date. If any one cell is blank or occurs in the past, I want the result to ...
1
vote
1
answer
22
views
Order file by colum where column is a date
I have a file in the following format
222 aaaaa 2021-12-24
333fd bbb 2021-09-1
444 cc 2022-01-16
555 zzz 2021-08-21
6666 www 2021-09-5
777 yyy 2021-03-14
888 xxx 2021-11-27
999 ffffff 2021-12-4
I am ...
- 13
0
votes
1
answer
20
views
Identifying files which were created on my local system at a certain date, despite "Date created" metadata retained from installer
I've installed a program, and all the files the installer created have identical "date created" and "date modified" metadata, indicating the date that the file was last modified by ...
- 111
0
votes
1
answer
66
views
Word field code can't calculate date less than 17 days out
I grabbed a bit of code to add in Word to calculate a date X days out from today's date:
{QUOTE
{SET Delay 17}
{SET a{=INT((14-{DATE \@ M})/12)}}
{SET b{={DATE \@ yyyy}+4800-a}}
{SET c{={DATE \@ M}+12*...
- 316
0
votes
1
answer
98
views
Excel doesn't recognize dates
I open clean workbook and type in 2021-12-14 or any other format it will not recognize is as a date.
When I type 42560 and change it to date number format I can display it as desired eg 9th of July ...
0
votes
1
answer
54
views
get a cell in the closest row of the previous year end
I have a row in mid year which I want to get the tax value of the previous year-end row.
Sometimes it will be year-12-31 and sometime there will not be that date, but a few days before it.
So in B17 ...
- 177
0
votes
1
answer
190
views
How to change default short date format to m/d/yyyy in Excel?
Default is now d-mmmm. That means when I type 12/6 Excel prints 6-Dec. I would prefer 12/6/2021.
Language/Regional format data -settings in Windows do not change short date format in Excel as far as I ...
- 129
1
vote
2
answers
742
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!...
- 15
0
votes
1
answer
664
views
How do I show dates in UK format in an Excel when viewed in a browser?
We have a sheet on SharePoint for Daily Standup notes. If I open the document in my browser, the date format is mm/dd/yyyy (incorrect). If I open in the desktop application, the dates show as dd/mm/...
- 7,983
0
votes
1
answer
286
views
MS Excel - assigning recurring weeks that reset every month
I have a set of dates say in column A and want to associate custom week numbers that reset after every 5 weeks.
So for example, the week counting starts from 27/09/21 (Monday) and will end on 31/10/21 ...
- 11
0
votes
1
answer
416
views
Bug in Excel-VBA IsDate()
The IsDate() function in Excel-VBA should recognize if a given string is/can be interpreted as a date.
But this macro:
Sub isdate_test()
If IsDate(Cells(1, 1)) Then
MsgBox "Yes"
Else
...
0
votes
1
answer
169
views
How can I prevent Excel from converting alphanumeric fields to dates?
I'm exporting alphanumeric data from a SharePoint list (single line of text datatype), but when my Excel desktop app opens the file, it changes "7-3" to "07/03/2021" and displays ...
- 11
0
votes
1
answer
48
views
Windows 10 time out of sync - Dualboot removed
I have been struggling with my windows 10 time for months now. It has been out of sync since I installed a Duelbooted Ubuntu OS. I tried all the solutions recommended on here that I could find but ...
- 1