77,680 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Best practices
0
votes
1
replies
19
views
Reload an iOS widget at midnight UTC
I'm designing my first iOS widget.
It provides a date in UTC time so, the best optimization, would be to refresh it at every UTC midnight. I found this way
let today00 = Calendar.current....
2
votes
5
answers
333
views
How to fix and parse dates based on unpatterened input formats
I am dealing with a dataset with four different inputs for dates in one date column (ymd, ydm, dmy, mdy). the dates in the column are input somewhat arbitrarily so lubridate::parse_date_time in any ...
0
votes
1
answer
67
views
Solr stores PostgreSQL date fields as epoch milliseconds (1667952000000) — how to keep pipe-separated date string like 2017年07月17日 | 2018年02月20日?
I'm migrating data from PostgreSQL into Solr. In PostgreSQL my priority dates are stored as two dates and I want them indexed in Solr as a single pipe-separated string:
2017年07月17日 | 2018年02月20日
I tried ...
3
votes
1
answer
174
views
Bash date calculates time addition incorrectly
I am writing a simple bash script for computing time and date by adding seconds onto a random date that I give. It worked fine so far but going from 2016年03月13日 00:00:00 to 2016年03月13日 03:00:00 skips ...
2
votes
2
answers
169
views
Two-digit year error when converting string variable into date variable (dates span from 1962 to 1981) [duplicate]
I have a dataset that spans 1962 to 1981. The dates are formatted as a string in a single field like this: 15-Mar-62.
When I use the as.Date function to convert the field into a date format (so I can ...
Advice
0
votes
1
replies
49
views
Using flask_moment to display a date in the web user's local format
I am learning from Miguel Grinberg's excellent Flask Mega-Tutorial and writing an app which tracks the items in two freezers. Dates are saved in UTC in the database but I want to display them in the ...
Best practices
0
votes
4
replies
142
views
Best way to extract a VBA Date out of a byte array and turn it back into a valid VBA Date?
I have confirmed that the following VBA code works just fine.
Dim mydate As Date
mydate = Date
Open "C:\Windows\Temp\dlctest.data" For Binary Access Write As #1
Put #1, , mydate
Close #1
...
-2
votes
2
answers
120
views
Add n days to a date [duplicate]
I have this code in my jsp page to list a payment to date:
<li>Paid Due Date: <fmt:formatDate value="${premiumPaidToDate.time}"
...
0
votes
0
answers
76
views
Django ORM: Add integer days to a DateField to annotate next_service and filter it (PostgreSQL)
I am trying to annotate a queryset with next_service = last_service + verification_periodicity_in_days and then filter by that date. I am on Django 5.2.6 with PostgreSQL. last_service is a DateField. ...
2
votes
1
answer
150
views
Testing Whether Two Date Column Values are Within One Year of Each Other
I have two date columns in R and I want to create a new column called Dates_Aligned that will return TRUE if the two dates are within one year of each other and FALSE if more than a year separates the ...
0
votes
1
answer
46
views
Calculating working days considering different weekends - Power BI DAX
I want to calculate the "working days" between 2 dates in Power BI. Middle east and north africa countries have different weekends (for example Egypt and Saudi Arabia Fri,Sat, the rest Sat, ...
4
votes
1
answer
150
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 ...
0
votes
2
answers
82
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
150
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
0
answers
123
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 ...