Questions tagged [date]
A date is a reference to a particular day represented within a calendar system, and consists of year, month and day. Use for questions about creating, manipulating and storing date information. Use with any relevant language tags.
76,966
questions
0
votes
0
answers
5
views
Getting Error [Microsoft][ODBC SQL Server Driver] String data, right truncation and Dates sorting incorectly
I am accessing a SQL database and pulling data that I will then filter further for a variety of uses. The current version which pulls properly includes a date column showing YYYY-MM-DD and I want it ...
-3
votes
0
answers
43
views
Exception in thread "main" java.time.format.DateTimeParseException: Text '04-Sep-2023' could not be parsed at index 3 [duplicate]
below is the datetimeformatter
DateTimeFormatter dtf2 = new DateTimeFormatterBuilder().parseCaseInsensitive()
.append(DateTimeFormatter.ofPattern("dd-MMM-yyyy")).toFormatter()...
0
votes
0
answers
22
views
Does Date object in browser update timezone correctly after changing system timezone frequently on Ubuntu?
I am encountering an issue where the browser timezone information becomes incorrect after changing the system timezone multiple times on my Ubuntu PC. Specifically, the Date object in my browser ...
0
votes
0
answers
8
views
Natural date parser for chat bot
I need a date parser in Node.js to parse or find dates from the user entered queries.
To design a chat bot - in chatbot user will be asking for a data for a particular date,
so the queries can be in ...
0
votes
1
answer
36
views
Excel Formula for Today's Month Being Greater Than Lookup Value Month & Provide Message
I have created a budget sheet in Excel to track Debt Snowball payments. I have a formula that successfully works to lookup the month from a list of months (column F) that a final payment is made for a ...
0
votes
2
answers
49
views
Is there any method to convert a varchar with specific format into time in Oracle SQL?
I have a table with three columns, one of the columns ateststatus_date has the following format: e.g:
28-MAY-24 11.57.20.000000 PM
and it's defined as varchar(2). I used To_date() and ...
- 11
0
votes
1
answer
56
views
Query between two dates gives incorrect results in SQL Server? [closed]
Im trying:
SELECT *
FROM database a
WHERE Applicant_End_date >= '2024-01-01'
AND Applicant_Start_date <= '2024-06-30';
Results:
Applicant_End_date shows results starting at 2024-01-01 like:
...
- 1
0
votes
0
answers
13
views
chrono-node month parsing issue
0
I've encountered a problem in which I am looking for a good solution.
I uses chrono-node for understanding which date the user is referring to , But chrono doesn't follows a strict rule in parsing ...
0
votes
0
answers
13
views
Sorting between two years
My first error with this query was the year, and I fixed that by only adding quotation at the beggining and end of the years. That gave me a different syntax error with the ORDER BY. Any suggestions?...
-2
votes
0
answers
17
views
Propagate letter date from page 1 through letter headers [closed]
Standard business letter template with user-entered date above the address block and greeting on page 1 of the letter template.
Is there a method in Word to propagate the letter date entered on page 1 ...
- 1
0
votes
2
answers
56
views
Why does moment.startOf go back 1 hour?
Edit: My local timezone is UTC+1
I have this date string: 2024-07-01T00:00:00.000Z.
This date string has a 'Z' at the end which denotes that it is in UTC (If I understand correctly).
When I run
...
- 123
0
votes
0
answers
13
views
Can't seem to get the date parameter to work
The following query works when I don’t add the last AND statement with the dates. However, when I add it, no results are found. I know this isn’t true because I populate data into the engine and know ...
0
votes
1
answer
49
views
Coding to convert Date from Worksheet to Textbox
I have my dates in worksheet but its appear format as number in textbox, and I'd like to convert them to dates in textbox. Whats code do I input to my userform?
Private Sub TBMOS_Change()
Me.TBMOS....
-2
votes
0
answers
24
views
Best Practices for Initializing Locale for Translations and Dates
I am localizing my app and have a few questions regarding best practices for handling locales, especially for translations and date formatting:
What is the best way to determine the initial locale ...
- 51
-2
votes
0
answers
18
views
Trouble with Date, change the format of the input string [duplicate]
I have a string with a date like this '12/07/2024 7:14' and I want to create a Date with that. The problem is that the new Date assume that is in united states format -> 'mm/dd/yyyy' and I want it ...
- 56
-1
votes
1
answer
72
views
javascript date increment by one day [closed]
I am trying to increment date by 1 day using javascript date object and print only the ymd format. The result date in the tomorrow variable after slicing is not 26 but 25 why so?
const d = new ...
- 8,994
0
votes
0
answers
62
views
Python Pandas reads inconsistent date formats from Excel files generated automatically with a 3rd part API
I'm using the PDF4me API to convert PDF invoices into Excel files. The dates are read correctly by the API. However, when I open the Excel files, the dates are displayed inconsistently:
Some dates ...
-4
votes
0
answers
22
views
Gent Rent availability in each hour for 2 weeks, depending on rent schedule, item quantity and current orders dates [closed]
I am trying to implement the function in PHP/Laravel (it is possible and advisable to use Carbon to work with dates) for this task, and don't know how to do this properly:
I have two arrays, one ...
- 489
0
votes
0
answers
26
views
What allowable date forms can be used in pandas bdate_series holidays?
I am currently testing the bdate_series to use in my code.
The following code still outputs July 2 as a date, even though I expected it to be excluded.
>>> pd.bdate_range(start='20240701', ...
- 321
2
votes
3
answers
104
views
How to trigger event on input date select when value is unchanged?
I am pre-selecting a date on <input type='date' /> and want the user to select a date anyway. If the date selected is the same as the pre-selected value, it does not trigger the change event in ...
- 1,778
0
votes
0
answers
27
views
Convert string to timestamp in pinescript
I'm importing a string that I then turn into an array. I would like to use the date and time values inside the array to draw lines from. The issue seems to be that a const string is expected. Is there ...
1
vote
0
answers
27
views
Date as number/text in YYYYMMDD format, but Excel won't format? [duplicate]
I'm working with a JSON dataset that presents dates as numbers in a column like so: 20190611, meaning it should be 2019-06-11. What can I do to get Excel to format these dates? Normal formatting doesn'...
- 115
1
vote
0
answers
30
views
Receiving TIMESTAMP instead DATE from POSTGRESQL DB to EXPRESS JS BACKEND
I am making a To-Do App. I use Express backend and Postgres DB to store users' data and tasks.
I have three tables in my DB:
users (id (primary key), username, password, name) => To store user ...
- 21
0
votes
1
answer
41
views
Why is the date format different from that of my project in recent versions of the mysql net connector?
System.Threading.Thread.CurrentThread.CurrentCulture=System.Globalization.CultureInfo.CreateSpecificCulture("es-DO")
System.Globalization.DateTimeFormatInfo.CurrentInfo.ShortDatePattern = &...
1
vote
1
answer
22
views
Display averages of a column for past five months in Google Sheets
I am working with a dataset that has multiple entries per month with different values. For instance, a row of data will have a certain month + year, as well as a value. I'd like to find the average ...
- 25
1
vote
2
answers
48
views
data frame breakdown by year, rounding up by duration of each period
I have a data frame of county executives and the first and last years they served.
I am running a panel study with county-year as the unit of analysis. The date range is 2000 to 2009.
I will like to ...
- 383
1
vote
1
answer
49
views
Parsing csv file output before certain date
I am trying to sort and parse lines in a csv file. So far I have been able to sort the date column. Assuming I can use sort to filter from a certain date - but all the info I find deals with different ...
- 13
0
votes
1
answer
28
views
Dart DateFormat problem, states can not read MM at position 8
I am trying to parse a date string that comes in on a string log entry.
The string is 20240716 154138
I am using this code and can not find why it is failing.
String timestampStr = '20240716 154138';
...
- 5,707
1
vote
0
answers
29
views
Display custom dates on x axis matplotlib
Here is my plot:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
import matplotlib.dates as mdates
dates = pd.date_range('2020-03-31', '2024-06-30', freq='...
- 7,549
0
votes
3
answers
57
views
Using nested lag or any other window function
I am working on a transaction dataset with one date column & one identifier column. Now retroactively I want to create a boolean column to check whether any particular activity (e.g. marketing ...
- 15