Questions tagged [date]

A date is a reference to a particular day represented within a calendar system, and consists of year, month and day.

Filter by
Sorted by
Tagged with
0
votes
0answers
10 views

Python : How to change the format of the values for the x axe?

I need to create a graph from data with python. I took my inspiration from various website and I've made this script : import plotly.express as px import plotly.graph_objs as go import statsmodels....
0
votes
0answers
7 views

Filtering a Series of dates in python on Even Months and End of Months

I am using spyder and python 3.8. I would like to filter a list of dates and only return if it is from and even month and the end of the business month, incorporating if it is a holiday. I have ...
0
votes
0answers
11 views

Change whole column data format from yyyy-mm-dd hh:mm to dd/mm/yyyy VBA

I am trying to convert the data format from yyyy-mm-dd hh:mm to dd/mm/mmmm I've been trying different solutions but none of them works, the closest one was this: Columns("I:I").Replace What:=" *", ...
2
votes
2answers
26 views

Overlap the intervals using mysql

+------+------------+------------+ | id | start_date | end_date | +------+------------+------------+ | 1 | 2019-01-01 | 2019-01-12 | | 1 | 2019-01-10 | 2019-01-27 | | ...
0
votes
2answers
18 views

Sumifs not calculating correctly

I have two tabs, one where I have dates and a number associated with the date. Another where it is broke down by month with the month's numbers. I am using this Sumifs to get the total for the month. ...
1
vote
2answers
23 views

Query with date comparision on Android with Room

I want to query my db with a date comparision with current Date. Here is my query : @Query("SELECT * FROM User INNER JOIN AutoLogin ON User.user_Id = AutoLogin.user_Id AND AutoLogin.token_Id = :...
0
votes
0answers
17 views

JMockit GregorianCalendar initialization

I need to Mock GregorianCalendar.class with JMockit so that : new GregorianCalendar() =====> new GregorianCalendar(2014,06,06); I need something like: new MockUp<GregorianCalendar>(){ @...
2
votes
3answers
31 views

merging two datasets based on common id and date within interval range

I have two datasets: DF1 - data frame which lists heads of states (leader_id) of countries (country_code) and an interval of their time in office (office_interval). DF2 - data frame where every ...
2
votes
2answers
38 views

Rounding times in time inputs to full hours or half-times

I need: XX:01 through XX:14 to round down to XX:00 XX:15 through XX:29 to round up to XX:30 XX:31 through XX:44 to round down to XX:30 XX:45 through XX:59 to round up to (XX+1):00 Notes: I gave ...
0
votes
1answer
28 views

How to convert a date string in one format to a string in another format (one with a timezone offset)?

I have a date in string format, e.g. 2020-01-10. What's the proper vanilla JS way to convert this to a string in this format--one with a time and time zone offset, e.g. 2020-01-10T00:00-0500 In my ...
-1
votes
1answer
18 views

How to assert an object containing `Date` properties using chai and deep.equals?

I have an existing typescript code base making use of the the native Date object. I want to add a testcases to it, yet when comparing my objects using deep.equals, I get a mismatch: AssertionError: ...
0
votes
1answer
25 views

How to transform a unique identifier's position over a time from multiple row to a single row?

I need help with a unique query, I couldn't find any solutions as yet. But that could be because I didn't know how to word what I am looking. Below is a sample dataset name, position, start_date, ...
0
votes
0answers
32 views

Manually move to year/month/day in date input with javascript / jquery

Is there a way to manually move to a different "column" (not sure what the terminology is) in the date input field using Javascript / jQuery? Here is an example of my code and what I'm trying to ...
0
votes
0answers
18 views

Set notification at specific date in Android

I'm doing a project in which I have a list of food like a virtual fridge. You can insert dishes based on a main ingredient and I want the app to notify the user when the dish is gonna expire. I have ...
0
votes
2answers
30 views

Adding days to a moment object is return same moment object

I've a moment object to which I'm trying add some days. However, it is returning the same moment object as a result. But, if I simply try to do it on the current date, it works fine. Also, note that,...
1
vote
2answers
29 views

How to select Overdue Rows with Date Frequencies?

+------------------------+--------+ | Invoice_id | due_date | amount | +-------------+----------+--------+ | 20 |2020-01-18| 1250 | +-------------+----------+--------+ | 21 |2020-...
1
vote
1answer
31 views

mongo get data within a month and year range [duplicate]

I want to get data within a month and year range. My documents are like this { "month": 12, "year": 2019, "accounts": [ 1094, 1093, 1087, 1081, ...
-1
votes
2answers
65 views

Incrementing month

I have a string which holds a month. String mon = "January"; Now, another string nextMon should hold the next month. That is, nextMon should be "February" if mon is "January". I get the mon string ...
0
votes
2answers
26 views

How to get the date difference in minus value in PHP

I'm trying to get the date difference in minus value if the start_Date is greater than the end_date. below is my code $diff = strtotime('2019-07-31') - strtotime('2019-07-21'); $date_diff = ...
-1
votes
1answer
23 views

SQL question: How to transform a string/char varibale yyyy-MM-ddTHH:mm:ssZ into date format and calculate difference between 2 dates

I have 2 string variables date1 and date2, ex: 2018-11-05T00:00:00.000+01:00 Now I would like to calculate the difference between these 2 variables in SQL that is not bigger than 60 days Am I missing ...
0
votes
2answers
23 views

Is there a way in R to convert my DateTime column into Date and Time with the format (“%m/%d/%Y” and “%h/%m/%s”)

I have the following data df that includes the Date Time Column: structure(list(DateTime = structure(c(1L, 2L, 8L, 9L, 10L, 11L, 12L, 13L, 14L, 15L, 16L, 17L, 18L, 19L, 21L, 22L, 23L, 24L, 25L, 26L,...
1
vote
2answers
28 views

How can i get the date and time from the datetime string in mysql

id user_id created_at status amount 16924 4387 15-03-2019 15:33 bill created 149250 16925 4387 15-09-2019 15:47 bill created 444600 16926 4387 31-07-2019 15:31 ...
0
votes
1answer
25 views

Merging two time data frames one after the other

What I am trying to do is to merge two data frames with observations of different variables by data. The first data frame contains observations for the period between January 2019 till January 2020 ...
-1
votes
0answers
6 views

How to check if the date is one of the rage [closed]

I have a list of date like : List n1 (19/01/2020, 22/03/2020, ...., 15/12/2020) ... List n6 (03/04/2020, 05/04/2020, ...., 12/11/2020) I need to check if the today date is one of the list. If yes, i ...
0
votes
1answer
45 views

Row_Number in table with key where ordering does not make sense

I am using T-SQL. I have a temporary table #t2 with only one column called internal. Values of the column are n times a sequence from 1 to 3 i.e. : 1 2 3 1 2 3 1 2 3 ... I want to add this ...
5
votes
3answers
50 views

Fetch empty/open time ranges in postgresql

I'm trying to find open shifts where: First shift starts at 6 AM Last Shift ends at 12 AM ie: Given the following data/day: start_time | end_time -----------|--------- 9 AM | 3 PM 5 PM ...
2
votes
3answers
29 views

Query filtering by week

How to query (SELECT) in Postgresql, so that the results of a column with different dates, are between Sunday and Saturday of the current week. Query fake example: SELECT * FROM table WHERE ...
0
votes
1answer
29 views

Is there a way to divide and map a date into months with their sum of daily value?

Im having trouble thinking of a way to create a function that can calculate the monthly spends of all combined projects in a system and return a map with month as its key and the monthly spends as ...
0
votes
2answers
41 views

how to combine years in group to 10 in a sqlite query

MOVIE (Mid, name, year, rank) i want to count the number of movies in a decade. Suppose year in the table start from 1931 then years from 1931 to 1940 will form a decade. My Query: query_7 = pd....
0
votes
0answers
21 views

How to format Excel Date into PHP?

In my excel, i have this date of the format d-M-y. My problem is upon import, the date becomes b115-Oct-04 instead of 15-Oct-04. If i use: $date = Carbon::createFromFormat('d-M-y', $sheetData[$i][3])...
0
votes
0answers
9 views

Reuters Eikon/Datastream - obtain issue date of structured products

I want to download the isse date (or the date were the first price was set up) of 1,000 bonus certificates of different issuers. To do so, I converted Wertpapierkennummern (WKN, identifier at German ...
-2
votes
0answers
18 views

How to extract data with varying frequency [closed]

I have daily, bi-weekly and monthly data. I need to build a monthly data table that picks up the closest (before or after) date from each table. Ideally the same date-Data function will allow me ...
2
votes
0answers
36 views

Error in typescript Property does not exist in type void

Well, it happens that I have some code made with angular bootstrap which is a data picker, which is inside an event party register(which you click new and make a new event) and I want the user to ...
0
votes
2answers
44 views

Convert date (YYYY-MM-DD) to day of year (0-364) [duplicate]

I have a column of data in a dataframe containing dates in the format YYYY-MM-DD. I need to create a column containing these dates converted to a single number representing the day of year (0-364).
1
vote
1answer
33 views

Using moment to round to next 1st or 3rd Monday

was wondering if someone could help, I am trying to use moment.js to take a date(like today) and then using it to return the next 1st or 3rd monday, whichever is sooner. So for example today as 01/...
1
vote
2answers
57 views

Using CountIF with dates before 01.03.1900 in Excel/VBA

I have a strange problem with Execl. The value of a specific cell ist 01.01.1900, the format of the cell is date-Format. When I try to count how many instances of 01.01.1900 there are via CountIf the ...
0
votes
2answers
41 views

Creating sequence of dates as new column in dataframe R

I have been struggling with a simple task (I guess). I have a dataset containing two columns with start and end date. I want to extract all the months between start and end date, and list them all ...
0
votes
1answer
45 views

How to set time “0000-00-00 00:00:00” to LocalDateTime?

To write test I need to set LocalDateTimeto 0000-00-00 00:00:00. When I try to set it using formatter: DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); LocalDateTime....
-1
votes
3answers
31 views

JQuery Sorting array of object using date [duplicate]

I have an array of objects which includes lastModifiedDate property in each object. I want to sort the array of objects according to lastModifiedDate property in ascending as well as descending order. ...
1
vote
2answers
32 views

Round (epoch) time to highest minute

I'm trying to get the epoch time from exactly 1 hour ago, rounded to the highest minute. E.g: 19:17:01 should become 19:18:00 & 19:17:59 should become 19:18:00 etc. I already know how to convert ...
0
votes
1answer
29 views

R:How to sort by ID and then detect the specific difference within the same ID and then show all the contents in one data frame?

I asked the similar question previously. R: How to sort by ID and then detect the difference within the same ID? But this time, I want to show the specific sample IDs within the same ID. My data ...
1
vote
2answers
29 views

R: How to sort by ID and then detect the difference within the same ID?

I have a dataset which contains several IDs and sample date column, like dataframe <- data.frame(ID=c("ID1","ID2","ID3","ID4", "ID2", "ID2", "ID3","ID4", "ID5","ID1"), ...
3
votes
1answer
22 views

Select records 1-2 years from begin date

I have two tables one that has a begin date, end date and age: Begin_Date End_Date Age 2015-12-14 00:00:00.0000000 NULL 1 2015-12-10 19:00:00.0000000 NULL 1 2015-12-09 19:00:00.0000000 ...
1
vote
0answers
49 views

Java Date_time parse exception

Within the context of ElasticSearch I am getting a Date parsing error. I am pretty certain its not ES itself but thought it would provide some context. Here is the error: "caused_by": { ...
0
votes
1answer
60 views

Spark Scala - Identify the gap between dates across multiple rows

I am new to Apache Spark, I have a use case to find the date gap identification between multiple dates. e.g In the above example, the member had a gap between 2018-02-01 to 2018-02-14. How to ...
2
votes
3answers
42 views

Counting cells per Date

I have a database of hotel rooms availability by date. Each day some hotels were available (Availablity = T) and some were not (Availablity = F). I am looking for a way to count the number of Trues ...
0
votes
2answers
53 views

SQL convert string in the form of yyyy-MM-ddThh:mm:ssZ to datetime

I have a variable in the format of string, such as 2019-11-25T14:22:56.529Z. And I need to extract the date part of this string variable and extract all records with the latest date. ID time (in ...
0
votes
0answers
11 views

match dates in unequal matrixes in matlab

I have two different matrices, one Matrix is 365x2 (date, return) and the other is 52x2 (every wednesday, return). Now I would like to match those two, but I'm struggling to achieve this. The ...
0
votes
0answers
43 views

Converting Month, Date, Year to FILETIME

Is there any function that converts a Month, Day, Year combination (e.g., "March 21, 2009"), to FILETIME? I don't mind doing it manually using a SYSTEMTIME, but anything Windows provides will be ...
0
votes
1answer
44 views
+50

scan dates from JSON and print specific content on the basis of date

I have a php code as shown below: Php Code: if (file_exists('feeds/ptp-ess_landing_house.json')) { $data_house = json_decode(file_get_contents('feeds/ptp-ess_landing_house.json')); } <?...