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,971
questions
0
votes
1
answer
56
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 ...
- 319
0
votes
0
answers
20
views
Convert DD/MM/YYYY to ISO 8601 format in Excel Sheet [duplicate]
I have a list of birthdays in the following format in Excel.
07/06/1987
04/04/1993
14/05/1973
13/07/1969
etc
I would like this to be converted to the format: 1987-06-07T11:31:01.805Z
How can I go ...
- 4,098
1
vote
2
answers
37
views
dataframe breakdown by year
I have a dataset on county executives and their year of inaguration. I need break down which year each executive was inaugurated.
The problem is that the notation under the "year" variable ...
- 383
4
votes
2
answers
69
views
How do I identify consecutive/contiguous dates in polars
I'm trying to isolate runs of dates using polars. For this, I've been playing with .rolling, .rle, and .rle_id but can't seem to fit them together to make it work.
Given this:
df = pl.DataFrame({
...
- 283
0
votes
0
answers
44
views
Getting Real Date and Time in Excel VBA if System time is on Manual [duplicate]
if a User has altered the System Time, the Date and Now functions return the ALTERED time. How to override this and still get the Real System time?
While using this code, I can't use Internet, ...
- 1
-1
votes
2
answers
39
views
How to create a new date by using one's date part and other's time part?
I have 2 dates in ISO string format. I mean 2024-07-25T00:58:00.000Z and 2024-07-30T13:35:00.000Z. I am trying to make them combine as 2024-07-25T13:35:00.000Z. Is there a way to do this with a simple ...
- 177
1
vote
1
answer
33
views
MySQL: Date String to Date to Month coming back as Null
The dates in this database are in the form of a string, and in this format:
"1/5/2019"
I can use this query to convert the string dates to a date:
SELECT STR_TO_DATE(`date`, '%m/%d/%Y') ...
- 2,853
2
votes
0
answers
60
views
ColdFusion Oracle 12c Two Year date defaulting to 1900s instead of 2000s
I have a form with a number of date fields in it.
input tag - cfinput type="text" name="orientation_date" value="#dateFormat(getData.orientation_date,'mm/dd/yyyy')#" ...
- 45
-1
votes
1
answer
60
views
Get LocalDate from the @RequestBody, convert it to dd/mm/yyyy format, convert it back to LocalDate and store it in the database
I am creating a Rest API applicaton which tracks users` expenses. I have date variable of type LocalDate and the default format is yyyy-mm-dd but I want to store dd/mm/yyyy in the database
what I ...
-1
votes
3
answers
75
views
Format date from YYYYMMDD to YYMMDD in Javascript
I have this code which shows the year in YYYYMMDD format. I would like the output to be in YYMMDD format. Basically to replace 2014 to 14 only.
let date = new Date();
let timeNow = new Date(date....
- 4,098
1
vote
1
answer
28
views
PowerBI line chart by month
I want to create a line chart that summarizes a percentage by month. The table has a column of type Date like 7/11/24 and a column of No/Yes to compute the percentage of Yes's out of the total.
...
- 10.4k
0
votes
1
answer
32
views
pandas/python: Seperate Date and Timestamp and delete duplicates
I have a data set that date and timestamp of createddate and closeddate is in 1 column:
CreatedDate ClosedDate
1/1/2023 0:00 1/13/2023 12:43
1/1/2023 ...
-2
votes
0
answers
32
views
Extract Month from time column 2024-06-30 [duplicate]
I have a data frame in using the R language with a "date" column YYYY-MM-DD and I want to extract the month and create a new column in my data frame named "month" with just the ...
-1
votes
2
answers
40
views
Merge data with overlapping dates in oracle
I have data in 2 tables and I need to split/and merge the data from table1 based on the data in table2 by looking for any overlaps in both. Can anybody provide tips to get this done in oracle?
Table1:...
- 101
1
vote
2
answers
65
views
getting the latest date for a a duplicated item in r [closed]
I have the following dataset (below).
I am trying to get the latest SEnd value for each individual tag (see Desired output) where I have the Tag, Owner and the latest SEnd date only. Essentially I am ...
- 105