Skip to main content
77,688 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
5 answers
241 views

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 ...
mel's user avatar
  • 21
-1 votes
0 answers
54 views

enter image description hereI have two tables that I need to join together and i'm possibly overthinking the issue. Baseline table has a entry for each month. In the actual table most applications ...
jc_sql's user avatar
  • 1
0 votes
0 answers
64 views

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 ...
Linux's user avatar
  • 37
3 votes
1 answer
155 views

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 ...
Redshoe's user avatar
  • 389
2 votes
2 answers
169 views

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 ...
mravi's user avatar
  • 21
Advice
0 votes
1 replies
44 views

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 ...
ChrisTucker's user avatar
  • 23
Best practices
0 votes
4 replies
127 views

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 ...
Dave Clark's user avatar
  • 163
-2 votes
2 answers
117 views

I have this code in my jsp page to list a payment to date: <li>Paid Due Date: <fmt:formatDate value="${premiumPaidToDate.time}" ...
runnerpaul's user avatar
  • 7,580
0 votes
0 answers
76 views

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. ...
Richard AR's user avatar
  • 59
2 votes
1 answer
149 views

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 ...
biscuitviolin's user avatar
  • 21
0 votes
1 answer
46 views

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, ...
devrinc's user avatar
  • 1
4 votes
1 answer
144 views

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 ...
JaecadeJnight's user avatar
  • 153
0 votes
2 answers
81 views

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-...
Francisco Augusto Varela Aguir's user avatar
  • 371
1 vote
3 answers
147 views

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/...
bach tran's user avatar
  • 11
0 votes
0 answers
120 views

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 ...
FUFY's user avatar
  • 19
0 votes
0 answers
14 views

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 ...
Sudipta Deb's user avatar
  • 509
-3 votes
2 answers
118 views

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 ...
Rhenz Idol Ii San Pedro's user avatar
  • 1
1 vote
0 answers
106 views

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 = "...
Y_O's user avatar
  • 11
-1 votes
0 answers
50 views

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 ...
Neglected Sanity's user avatar
  • 1,480
0 votes
1 answer
68 views

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 ...
Stuart L's user avatar
  • 181
0 votes
3 answers
115 views

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 ...
ControlAltDel's user avatar
  • 35.3k
0 votes
0 answers
118 views

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 ...
Hollycene's user avatar
  • 627
0 votes
1 answer
119 views

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 ...
ndtorre's user avatar
  • 31
1 vote
2 answers
95 views

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 ...
Tom Carron's user avatar
  • 11
0 votes
1 answer
61 views

I want to change the format of an axis from mmm-yy to qq-yy. Example, I want "Dec-22" to be "Q4-22". The dates are NOT in the data, so I can't change the date format in the data ...
bereedcpa's user avatar
  • 1
3 votes
2 answers
113 views

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, ...
sayana_dutta's user avatar
  • 73
1 vote
0 answers
85 views

Currently, in Java I have tested using IBM SimpleDateFormat and Java DateTimeFormat, both cannot parse "Rab, 25 Agt 2025" due to IBM and Java only recognize "Agu" Is there any ...
Deddy Chandra's user avatar
  • 41
3 votes
3 answers
216 views

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, ...
Jessie Elliott's user avatar
  • 33
0 votes
0 answers
71 views

I'm working on an application that uses lancedb's Rust crate for storage. I'm saving dates as unix integers, but LanceDB formats them as iso strings with a trailing decimal... sometimes. Last Read: &...
Andrew's user avatar
  • 642
0 votes
2 answers
148 views

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 ...
Winston Smith's user avatar
  • 29
2 votes
3 answers
103 views

I have 2 date attributes stored as text strings that need to be compared with earliest date selected. In the output shown here, you can see for ID 1 the earliest date has not been correctly identified ...
RyanB's user avatar
  • 103
1 vote
2 answers
103 views

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 ...
Thomas Slade's user avatar
  • 183
4 votes
3 answers
142 views

Why is pandas not formatting dates with date_format argument of to_csv? pandas.DataFrame([datetime.datetime.now().date()]).to_csv(date_format="%Y %b") ',0\n0,2025-07-31\n'
Hugo Trentesaux's user avatar
  • 2,101
2 votes
2 answers
75 views

I have 2 inputs (date and number) in view - blade, like this: <div class="col-3"> <label for="jatuhtempodate">Jatuh tempo</label> <input name="...
ronny hidajat's user avatar
  • 31
2 votes
3 answers
185 views

I am trying to calculate the next month in YYYY MMM (e.g. 2025 Jul) format using year and month as inputs. What I have is this: text <- "Current year is 2025" mon <- "06" ...
JontroPothon's user avatar
  • 662
-2 votes
2 answers
266 views

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 ...
buggy's user avatar
  • 37
-1 votes
1 answer
73 views

I have a CSV file and need to change the date format in each record within a specific field. The file has headers and is comma delimited. I need to change this: Despatch_date [date],Order_Number,Name,...
Steve's user avatar
  • 1
1 vote
2 answers
70 views

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 ...
Michelle Lehman's user avatar
  • 13
-2 votes
1 answer
98 views

Apologies, I'm very new to all of this. I have this problem with my X-axis, where it is too overcrowded with dates and times. This can be seen in the graph that I have produced: Graph produced so far ...
Leo Lasrado's user avatar
  • 1
3 votes
1 answer
98 views

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,...
TUS's user avatar
  • 33
0 votes
0 answers
27 views

The DateWrapper popover is appearing at the top-left side of the button. I've tried fixing it, but it's still not working. how to fix it? <Box sx={{ display: "flex", ...
Anjali Gupta's user avatar
  • 1
0 votes
0 answers
38 views

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 ...
Chloe Whalen's user avatar
  • 1
0 votes
0 answers
42 views

I have a form with 2 fields called "From Date" and "To Date", both with jQuery Datepicker widgets. These date fields are user selected and represent the start and end dates of a ...
emanresu_123's user avatar
  • 64
0 votes
1 answer
112 views

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 (...
Jess's user avatar
  • 25.4k
0 votes
1 answer
37 views

I want to select all calls happened or at least started or ended between 2 date range in dynamodb. Partition key is some id and sort key is leftRoom. Is it correct approach? left is end time, started ...
Enkhbayar's user avatar
  • 1
0 votes
0 answers
53 views

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 ...
Cryotech's user avatar
  • 13
-2 votes
3 answers
97 views

I have a spreadsheet where all of the columns including dates are written as an unformatted string of numbers - ex, "7112005" is "july 11, 2005", and 8282020 is "august 28, ...
dmac's user avatar
  • 19
1 vote
1 answer
89 views

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 ...
Jude's user avatar
  • 325
2 votes
1 answer
57 views

I have a dataset with multiple observations per subject over time. The dates for the first and last observation per individual are different across the dataset, but for each individual there is only ...
Ariel Mundo's user avatar
  • 93
0 votes
3 answers
210 views

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 ...
dok's user avatar
  • 469

1
2 3 4 5
…
1554