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,949
questions
0
votes
0
answers
7
views
getting the latest date for a a duplicated item in r
I have the following dataset.
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. Essentially getting the latest ...
0
votes
0
answers
12
views
How do I disable any kind of automatic conversion into excel when using xlwings?
When using xlwings, I want to, for example, write the string "4 / 5" into excel. However, if I write.
sheet[0,0].value = "4 / 5"
I get: string converted to date
I do not want to ...
-5
votes
1
answer
24
views
how to extract the local time and year when given a UTC time in milliseconds and the timezoneOffset?
In javascript, one is given:
UTC milliseconds since 1970
timezoneOffset of the local timezone
From the above, how to extract the local time and year implied by the timezoneOffset?
0
votes
0
answers
27
views
MySQL Date Column Index (NO Datetime)
I have a table with a date column (NO datetime, date only), which I always use to retrieve information by YEAR using BETWEEN. I was wondering if it's more efficient (and faster) to add a column to ...
0
votes
0
answers
8
views
On R Identify when a qualitative variable changes from one value to another
On the x-axis I have dates and for each date I have a qualitative variable (colour). I would like to create on R a new df with the date on which my variable changes (e.g. the date from which I turn ...
1
vote
1
answer
41
views
Error: Unable to convert "Invalid Date" into a date in angular
html:
<div class="form-group">
<nz-date-picker
class="mt-2"
formControlName="obsolete_date"
[nzDisabledDate]="disabledDate"
*ngIf="...
-1
votes
0
answers
36
views
Highlight a date in JavaFX DatePicker and use that value
I am trying to highlight a date when I click on it on the calendar part of JavaFX datepicker, once highlighted I want to get the value of that date to use it further (as an example let’s say I want to ...
0
votes
1
answer
21
views
Exclude dates not within specific ranges from a user-selected date range in node.js?
I have an array of multiple start and end date ranges and a user-selected start and end date range. I need to exclude the dates from the user-selected range that do not exist within the specified date ...
0
votes
0
answers
14
views
Type Mismatch while using FlatFileItemReader BeanWrapperFieldSetMapper from String to Date
I am trying to batch process a file which has date field. Now when I fetch Date field using FlatFileItemReader it comes as a String.
I am trying to map it to following entity
@Entity
@Data
public ...
-3
votes
1
answer
37
views
JavaScript Date.getDay() returns the wrong day but only for some users [closed]
I'm working on a website for a conference and some users complain that the day of the week in the dates displayed in the schedule is wrong: instead of e.g. "August 3rd (Saturday)" they see &...
0
votes
1
answer
73
views
Completely illogical Date() values, in Swift
When I try to add a time interval to a given date at the end of some of the months, I get illogical results.
In the following example, when I add 5 hours to an 8:00PM time, in the given date, the ...
0
votes
1
answer
13
views
OpenOffice spreadsheet not sorting dates set to "D MMM YYYY" format [closed]
I have a date column which has dates in this format:
Last Login
04 Jun 2024
10 Jun 2024
10 May 2024
13 Jun 2024
I have highlighted the column, then gone to Cell Format, and then chosen the Date ...
0
votes
0
answers
15
views
Date Object dont recognize a string using XLSX
I'm using XLSX package to read an excel file and for some reason some Date Objects are Date and others are string.
I'm using this line to define cells as Date type.
const workbook = XLSX.read(buff, {...
0
votes
1
answer
29
views
How to mutate a year quarter str into date?
I have a df that comes from an api with a Trimestre (Código) column in string format:
pib$`Trimestre (Código)` <- c(199101,199102,199103,199104,199201,199202,...)
but i need to mutate this column ...
1
vote
3
answers
53
views
Python Pandas: update last dates values of parameters with simple dynamics grouped by id
Here's a dataframe, with some parameters for each id by some regular quarterly dates. It's originally shuffled randomly, but, at first, let say, it is sorted by fab_date and id.
import pandas as pd
np....