77,141 questions
-1
votes
0
answers
13
views
Why is this 5 Hour Date Histogram bucket starting at 3am?
So I know that Date Histograms can be quite tricky, so I have tested this in as easy of an environment as possible.
I have an index with 1 document. This document has a date field "2025-04-25T05:...
- 2,603
-6
votes
2
answers
67
views
String Date Calculation [closed]
Currently I am storing my dates in the following format "YYYYMM" and would like to subtract one month from the date. For example, if the date were "202401" I would like to have a ...
-3
votes
0
answers
45
views
Inconsistent Date Format Between Identical Web Applications on Same Server [closed]
I have two identical web applications published on the same server — one for testing and one for live. Recently, the live version started having issues, even though there were no problems before.
...
- 183
-3
votes
1
answer
48
views
main.py:6: SyntaxWarning: invalid decimal literal [closed]
day = int(input("Enter a day (1-31): "))
if day < 1 or day > 31:
print("Error. Day must be between 1 and 31.")
month = int(input("Enter a month (1-12): "))
if ...
-4
votes
0
answers
60
views
SQL Server 2022 with text field to SQL Server 2019 field(date) How can I add this variable to the date column without any problems? [closed]
using (var cmd = new SqlCommand())
{
string incomingValue = hfStartTime.Value.ToString();
string[] parts = incomingValue.Split(' ');
string date = parts[0;
string hour = parts[1];
...
3
votes
3
answers
77
views
Find Days Difference between two UK dates in vba userform
These dates are produced by Trevor Eyre's calendar in USA format so I have converted to UK for my users. However I guess that is why I can't find date difference as no longer a number. Is there a way?
...
- 67
0
votes
1
answer
10
views
REDCap Report mismatched datetime
I have several dates for the same event that should all match and want to generate a report using REDCap that outputs participants that have a mismatched dates.
I tried using the following code for ...
2
votes
2
answers
285
views
How to postpone certain holidays that fall on weekend
I live in a country, where by law, certain holidays are not allowed to fall on a weekend. If they do, they need to be delayed to fall on the first available working day.
For example, the holiday of ...
- 67
0
votes
1
answer
49
views
How do I enter a date in Applescript in order to create a calendar event?
Trying to script new calendar events for use with Raycast (which is limited in that it can't add 0 duration or all day events, can't add alarms.)
The following code results in
error "Calendar ...
- 91
0
votes
1
answer
67
views
Filtering by month name after EXTRACT(MONTH) – best practice or mistake?
I’m writing a query to calculate the total monthly sales per employee and display only the data for April. I’m using PostgreSQL, and while the logic seems fine to me, the output isn’t working as ...
1
vote
1
answer
76
views
Change current date (Sys.Date()) for testing purposes
I'm writing a function that executes some logic, but if today's date is after a certain day, it's supposed to execute different logic. Let's take an example:
to_be_tested <- function(msg) {
if (...
- 477
-1
votes
3
answers
93
views
COUNTIF using DATE only and name match criteria
I have been tasked to count how many leads does a sales agents takes everyday. So I created a spreadsheet, where the data is being auto populated from a CRM platform, and a separate tab for the ...
- 3
-3
votes
2
answers
160
views
Does Instant.MAX need to be manually formatted? [closed]
DateTimeFormatter fails on valid Instants. How it is meant to format those below and above LocalDateTime.MIN and LocalDateTime.MAX? Manually?
DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"...
- 1,637
0
votes
0
answers
49
views
pytz library timezone conversion issue [duplicate]
I am trying to work with django and converting timezones between UTC and my timezone ("America/Winnipeg"), but I keep running into issues and I think there might be a bug. Here is my code:
#...
6
votes
3
answers
226
views
Vapor - Dates not serialized as Strings
I am writing a server-side Swift app using Vapor. I have a transfer object model that looks like this:
protocol TransferObject: Content {}
protocol TimeAuditedTransferObject : TransferObject {
...
- 12k