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
44
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 ...
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:
...
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 ...
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
...
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 ...
-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 ...