77,693 questions
Best practices
0
votes
4
replies
99
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
...
- 153
0
votes
0
answers
69
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. ...
- 59
0
votes
1
answer
34
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, ...
- 1
0
votes
2
answers
78
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-...
0
votes
1
answer
108
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 ...
- 19
-3
votes
2
answers
101
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 ...
0
votes
0
answers
48
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 ...
- 1,482
0
votes
2
answers
71
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 ...
- 35.2k
0
votes
1
answer
89
views
MuleSoft DataWeave Date Time Formatting
Using input payload of
{
"Date": "2025-09-09T18:03:06.830"
}
I'm trying to get an output of
"2025-09-09T18:03:06.830Z"
I've tried this DataWeave
%dw 2.0
output ...
- 31
0
votes
0
answers
54
views
Selectable Calendar in Visio
I hope you're doing well!
I have added a Date Field to my Visio file. But every time I need to add a date I need to go to the "Shape Data Window" to enter the date. I saw somewhere that it ...
3
votes
2
answers
101
views
How to cast a timestamp to date in format YYYY-MM-DD in griddb
I created a collection container name ‘orders’ with the below DDL using NewSQL Interface:
CREATE TABLE orders
(
orderId STRING PRIMARY KEY,
customerId STRING,
orderDate TIMESTAMP,
...
- 73
3
votes
3
answers
214
views
Mutating detection data into binary
Currently I have a dataframe of bear detections that I want to convert into a binary detection history (14 columns of day1, day2, day3, etc. where:
actual_date_out = the date the camera was deployed, ...
0
votes
2
answers
140
views
Change displayed format in worksheet for path and filename in VBA
I have an Excel worksheet with a specific cell for a customer and another cell for a date formatted as mmm dd, yyyy
When writing VBA code to create and record the worksheet as a PDF file in a folder ...
1
vote
2
answers
99
views
Regex in Excel not matching a date when that date has a slash in it
I need to find where a date value is later than the year 1911. Some of these values aren't uniform: some are Jan-1910 (beneath the formatting this is 01/01/1910, others are 1910-1914. Dates before ...
- 183
2
votes
2
answers
62
views
How to toggle between input date and input number in Laravel 12 - Livewire
I have 2 inputs (date and number) in view - blade, like this:
<div class="col-3">
<label for="jatuhtempodate">Jatuh tempo</label>
<input name="...
-2
votes
2
answers
258
views
Why does Java Date always display in system time zone instead of UTC?
I am working on a Java 8 application where I receive epoch millisecond timestamps that represent UTC time. I need to pass these timestamps as Date objects to a method that I do not control (from a ...
- 37
1
vote
2
answers
68
views
Consolidate date ranges using Teradata
I need to take a list of date ranges and consolidate them. In our existing table, sometimes the FROM_DT and TO_DT are the same and the FROM_DT in the following row is 1 day after the previous row's ...
3
votes
1
answer
89
views
Sorting a List based on Start and End dates with no Overlapping dates
I have a concept which I have trouble into converting it into code.
The basic idea is as shown below image
Display data with non-overlapping dates
The picture might not say much. To describe the issue,...
- 33
0
votes
0
answers
34
views
Creating seaborn histplot with dates instead of data's default dates
I'm wanting to format this histplot in seaborn so that it includes the date range for the entire dataset I have, not just the range in which this variable occurs. Histplot with code above, shows data ...
0
votes
1
answer
104
views
Bootstrap 5 date input does not accept paste
We recently upgraded an application from Bootstrap 4 to 5. Since the upgrade, users are unable to paste into <input type="date"... controls.
I scoured the Bootstrap 5.3.x documentation (...
- 25.4k
0
votes
0
answers
49
views
EXCEL - Comparing multiple dates against a single date value for highlighting
I'm trying to use conditional formatting to compare the date output from multiple cells and columns against one date value.
The condition works but in an undesired state. The condition evaluates ...
- 13
1
vote
1
answer
83
views
Filter data with dates based on condition
I need to filter my data based on two sets of conditions and dates: For the stations not including "150" in the station's name, I need to filter with start_date_AN and end_date_AN and for ...
- 325
0
votes
3
answers
193
views
How to allow date input in yyyy-MM-dd format without external libraries?
I'm building a Java Swing application where users need to enter a date in the format yyyy-MM-dd.
I want to use only standard Swing and Java components, without external libraries like JCalendar or ...
- 469
1
vote
0
answers
54
views
Converting a input type date in html to a time.Time date type in GO [duplicate]
A small example of the code
The backend example:
package main
import (
"time"
"github.com/gin-gonic/gin"
"github.com/go-playground/validator"
)
type ...
0
votes
1
answer
76
views
Event load can't be found BC30590
I comeback with an error BC30590 the event Load can't be flound. I want to display date and time on a mMain form This is the code but is not working. Thank you very much.
Public Class MainForm
...
