77,698 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
4
votes
1
answer
81
views
How to get a JavaScript "days since 2000" that is identical to that of Scratch's block of the same name?
What do I need to do to make a "days since 2000" JS function that provides a value identical to that provided by the reporter in Scratch?:
The Scratch Wiki page states that
It reports the ...
-1
votes
2
answers
65
views
Compare two Excel sheets by SKU, Price, and Date Ranges — highlight mismatches
Sheet 1: sell_in
Column
Name
Example
A
SKU
12345
B
Price
59990
C
Start Date
01-09-2024
D
End Date
30-09-2024
Sheet 2: oficial_prices
Column
Name
Example
A
SKU
12345
B
Price
59990
C
Start Date
01-09-...
1
vote
3
answers
114
views
Change a column of data that contain 2 different date formats
I want to use Power Query to change a column or add a custom column that contain 2 different date formats individually to each format.
My column curently has dates in 2 formats: yyyymmdd and dd/mm/...
0
votes
1
answer
90
views
Sorting completed date in WooCommerce order list (admin dashboard)
I added a new column of completed date in the woocommerce order list page using the code here. The new column shows sorting buttons (up/down arrows) properly but when clicked, seems like it sorts on ...
0
votes
0
answers
8
views
lightning-input of type date behaving strangely in lwr sites
I have the below lwc which I am planning to use inside lwr. But the behavior is different/strange. For example: when I am giving some wrong date like Nov 39, 2025. it automatically chooses the next ...
-3
votes
2
answers
83
views
Get Previous Month Date - Google Sheets
Using the formula =EDATE(A2, -1) to subtract one month from a date that falls on the 30th, when it reaches February, which has only 28 days, the formula returns the 28th. For the following months, it ...
-3
votes
0
answers
102
views
How can I automatically add a timestamp when a cell gets filled in Excel?
I'm trying to track how long it takes between when data gets entered and when we actually execute on it. Right now I've got VLOOKUPs pulling in all the data I need, but I'm stuck on getting timestamps ...
1
vote
0
answers
100
views
DIST Alert Data Extraction Issue
I am trying to extract data about the DIST Alerts using the following script:
import requests
API_KEY = ''
API_BASE = "https://data-api.globalforestwatch.org"
DATASET = "...
0
votes
0
answers
40
views
Ordinal day of month in kotlin [duplicate]
I'm trying to figure out how to get a more complete date in kotlin, not just something that says Tue, Jan 1 but has the ordinal part of the day, so Tue, Jan 1st I have tried searching ordinal date in ...
0
votes
1
answer
63
views
Time values not adhering to set format
As part of an onEdit function, I compare two times. If the second time is less than the first time, I will get the user to re-enter the time so that it is later. My problem is in comparing the two ...
0
votes
2
answers
67
views
I can't create repeated events using ICS.js
I am struggling with ics.js (https://github.com/nwcell/ics.js/)
It is ignoring rules for repeat events set up in rrules
It is not allowing me to add another event from another .ics file after I have ...
-1
votes
0
answers
20
views
SDD and HDD differ with regard to changing Date Modified of Folders [migrated]
So maybe I'm wrong about this but it seems that SSD's do not reset the Date Modified attribute of a folder if a change has occurred within that folder (file created, moved to, etc...). Only HDD's ...
0
votes
0
answers
105
views
Why does Text(date, style: .relative) show the same duration for different dates?
I’m using SwiftUI’s Text(_:style:) with the .relative style to show how long ago a date occurred. According to the docs:
A style displaying a date as relative to now.
I expected it to show the ...
0
votes
1
answer
71
views
MuleSoft DataWeave Date Time Formatting
Using input payload of
{
"Date": "2025年09月09日T18:03:06.830"
}
I'm trying to get an output of
"2025年09月09日T18:03:06.830Z"
I've tried this DataWeave
%dw 2.0
output ...
1
vote
2
answers
91
views
How do I change a cell value based on the current month/year and the
I want to have the time weight value in column J automatically change based on the current month/year and the month/year in column L. For event occurring within the past 6 months (sept 25 to april 25 ...