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,985
questions
0
votes
1
answer
34
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 ...
-6
votes
1
answer
50
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
28
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
12
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
55
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
47
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
24
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
18
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
40
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
78
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
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
30
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
55
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....
0
votes
0
answers
160
views
Calculate Week Number of Year in T-SQL without DATEFIRST function or other database objects
I am working on a SaaS application that connects to a Microsoft SQL Server database, using T-SQL language.
I cannot develop stored procedures, user-defined functions, or any database objects.
I am ...
-4
votes
1
answer
56
views
how to sort a sequence of numbers treating them as a date but without zeros
These are sample 3 strings. The numerical sequence has no zeros. The correct date is on the right
P_2024713812 - "2024-07-13 08:12"
P_20241151212 - "2024-11-05 12:12" <-- last
...