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,954
questions
-3
votes
0
answers
18
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 ...
0
votes
0
answers
20
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', ...
1
vote
2
answers
44
views
+50
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 ...
0
votes
0
answers
15
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
24
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'...
1
vote
0
answers
29
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 ...
0
votes
0
answers
33
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
21
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 ...
1
vote
2
answers
45
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 ...
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 ...
0
votes
1
answer
26
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';
...
1
vote
0
answers
28
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='...
0
votes
3
answers
50
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 ...
0
votes
0
answers
28
views
Cannot use IN function for Partition Filter of a View Table in BigQuery
so I have a view table named table_1 and it has a partition field called business_date. Thie table_1 is constructed by using a raw table named data_mart.customer_raw.
There are a lot business needs ...
0
votes
0
answers
38
views
date-fns returns invalid time zone specified [closed]
for example:
format(dateToFormat, formatStr, {
timeZone: 'Asia/Bangkok',
});
here,
dataToFormat = Thu Jul 11 2024 13:11:48 GMT+0530 (India Standard Time)
formatStr = dd MMM yy, hh:mm a XXX
this is ...