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
1
vote
1answer
17 views

Date-bound running average in Postgresql - how to partition into four weeks

I have a table with sales_date (weekly: every Saturday), item_ID, and sales. I want a four-week running average. I need to partition my data into four-week sections per ID, but I can't work out how to ...
0
votes
1answer
15 views

How to adjust dates to GMT?

I need to display items from DB on specific dates. On the DB, those items are stored using GMT (+0 timezone). The client, for example has +12 timezone. Now if the user requests for items whitin the ...
0
votes
0answers
30 views

How can I compare times in an array?

I am building a bus arrival time application. It needs a function which is passed two arguments. A current stop which the user is at, and a destination stop which the user wants to go to. The arrival ...
0
votes
2answers
38 views

Convert JS date format into localized human readable format

How should I convert a date format of YYYY-MM-DD into a human readable format %e %B %Y in JS by taking into an account a different language from system's locale? In PHP it would be like <?php ...
0
votes
1answer
16 views

Interpolation of sparse time-related (datetimes) entries

I am trying to interpolate data through time. I have sparse data points generated on some dates (which I can draw with the code below) and I am trying to draw a continuous interpolation path or a ...
1
vote
0answers
18 views

Linq.js for dates between in jquery

I am using moment.js and linq.js library in my code Now requirement is to create DataTable for each unique date and if the from date and to are not on same day than I want to create more tables for ...
0
votes
3answers
57 views

SQL - temporarily set default date when parsing time as datetime in SSMS

if I do SELECT CAST('11:30 pm' AS datetime) I get 1900-01-01 23:30:00.000 but if I do SELECT PARSE('11:30 PM' AS datetime using 'en-gb') I get 2019-08-20 23:30:00.000 i.e. parse gives today's ...
0
votes
1answer
21 views

How do i retrieve data from YTD to last sunday?

I'm trying to make an SQL code so it automatically extracts data from the current year and until last sunday.. The first part was fairly easy, but I'm struggling with dynamically adding last sunday.. ...
0
votes
1answer
28 views

How can I echo several weekdays(only monday and tuesday) between two dates? [duplicate]

How can I echo next Wednesday and next Tuesday like modify('next Wednesday and Tuesday')? How can I echo next Wednesday and next Tuesday between two dates like modify('next Wednesday and Tuesday')? $...
-2
votes
0answers
16 views

How to convert to carion date format in c#? [duplicate]

I am using an API for some software and it is requiring me to pass a date in a clarion format. Was is this format and how do I convert a date into it?
2
votes
2answers
81 views

How do I get the current day of week in C++ using date.h?

I am using C++ 14 and am trying to get the current day of week. After some reading I am using date.h by Howard E. Hinnant. However I am struggling to get a day of the week (encoded as 0 thru 6). ...
0
votes
2answers
35 views

Zoned timestamp format conversion in Python

My file has data like below a,b,d,f,e,2014-09-16T01:57:48.295Z,2017-07-13T02:01:03.059Z s,d,fe,r,t,2014-09-17T01:57:48.295Z,2017-07-23T02:01:03.059Z wa,db,td,yf,de,2013-09-26T01:57:48.295Z,2017-07-...
-7
votes
0answers
44 views

Want to access immediate next date of today [on hold]

screenshot Want to access immediate next date of today from the array. var dateLists = [ '2019-08-01', '2019-08-04', '2019-08-05', '2019-08-07', '2019-08-09', '2019-08-10', ...
-1
votes
1answer
36 views

Reformat date in PHP

I have a problem. I've a date input on my site. When the input type date is not supported by the browser, I'm initializing a jQuery datepicker. The problem is, that the normal date input returns the ...
-3
votes
0answers
26 views

How to add days to a JavaScript date [duplicate]

Using JavaScript, there is a start date, which is Monday and I need an end date which will fall on a Sunday, therefore, I am trying to add 6 days on to the mondayDate to get the Sunday date, which ...
0
votes
1answer
19 views

Comparing day of week to String literal name for day of week returns false

I am comparing the day of week values to their string literal equivalents, but am consistently getting false. I have a relatively straightforward string DoW to 'monday' comparison setup in SQL Fiddle, ...
3
votes
1answer
76 views

How to find all week numbers of month that are the # week of month in a year with Java

as I said in title I am looking to build up a function that return an array with all week numbers of the previous months in a year that are the same week number of one particular month. I am using as ...
0
votes
0answers
21 views

REST (JSON) - Check if a date is between two dates

I need to be returned by a REST, all jira sprints that are between a date. To be more precise I need the Json that is returned by REST to be filtered as follows. Sprint.completedDate> = StartDate ...
-3
votes
0answers
26 views

Comment convertir une date en string avec jsf [on hold]

Bonjour je suis débutante en java avec le fromwork JSF, depuis quelque jour je cherche à convertir une date mais impossible d'obtenir quelque chose voici mon code <h:column id="datehos"> ...
2
votes
0answers
14 views

How to extract dates from a Certificate of Disability with Tesseract?

I want to develop a tool, that extracts the sickness dates from a certificate of disability. In Germany these certificates are standardized forms ("Arbeitsunfähigkeitsbescheinigung"), that contain ...
0
votes
0answers
27 views

Is there any way to get the last modified element in a dictionary in python without using 3rd party libraries?

I have a .txt file with a dictionary of words and related sentences, whereby it's {word:sentences, word:sentences,... etc.} While I only managed to get the last modified time of the file and the last ...
-1
votes
1answer
34 views

Cannot convert date to the right format

I want to convert "query" to "09/08/2019". The code below is throwing "String was not recognized as a valid DateTime" (IsDate(query) returns true though): query = "09 August 2019 00:00:00" Dim Ddate ...
4
votes
4answers
68 views

DateTime Convert from MMM-yyyy to dd-MM-yyyy or yyyy-MM-dd

I'm submitting date value from view in format MMM-yyyy i.e. "Apr-2019" as string. I need to get the string value converted into .Net supported date format like dd-MM-yyyy or yyyy-MM-dd. Here dd will ...
0
votes
0answers
25 views

Connect mysql timestamp with Java [on hold]

I am trying here to connect MySQL datetime(6) with my code. Basically I want that when you press the button then my database will save the current date. I am here trying to do little borrowing system. ...
0
votes
2answers
21 views

How to create full time string from hours and minutes in Moment.js?

I have time strings having only hours and minutes, for example '19:39', '21:37', '14:10'. I'd like to put such a string in a moment.js function like format() and get a string with seconds: '19:39:00',...
-5
votes
1answer
32 views

Calculating age between DoB and date of death [on hold]

I am new to Python and I have a question on how to calculate the age of a person based on date of birth and date of death (if the person is still alive and date of death is NOT today). If the person ...
1
vote
2answers
47 views

javascript - display date as a string without padding of “01” if the date is only composed from year and month

I am getting a date in some format ('yyyymmdd' or 'yyyymm') and need to display it as a string in my current locale. For this example, the locale is 'en-GB'. When I get the full format(yyyymmdd), I ...
1
vote
1answer
31 views

How To Identify days before and after a holiday within pandas?

Objective: to identify 2 days before the holiday and 3 days after a holiday by making things binary. Details: Specifically I am trying to get a result to df['is_2_days_before'] and df['...
-1
votes
0answers
15 views

How to sort tuple type dict values based on a date contained in each value tuple

I'm working on a project and want to sort the values (which are tuples) in a dict based on a date contained inside the tuples. Here is an example of what the dict_entries look like, the values are ...
0
votes
1answer
44 views

How do i add two dates that are saved in .json files?

I am having a hard time summing two dates that are saved in two separate json files. I want to add set dates together which are saved in separate libraries. The first file (A1.json) contains: {"...
0
votes
5answers
63 views

How to divide 1d array which contains dates to several smaller arrays (2d array)

I have an array contains dates (yyyy/mm/dd format): ["2019-02-05", "2019-02-06", "2019-02-07", "2019-02-08", "2019-02-09", "2019-02-10", "2019-07-05", "2019-07-06", "2019-07-07", "2019-07-08", "...
0
votes
1answer
38 views

COUNTIF in a matrix using different date formats

I am working on an excel sample data (Sheet 1) that is related to flight bookings. The columns I am interested in are the booking and check-in date. I have created on a separate sheet (Sheet 2) a ...
0
votes
1answer
61 views

Using big dates in c#

I need to manage big dates, since universe creation (-15 000 000 000 to now). DateTime only allows to work from 0001/01/01 to 9999/12/31. (I don't need month-day-hour-etc.. resolution before 1000 BC). ...
0
votes
1answer
22 views

JavsScript keeps subtracting PHP/MySQL date format

I am trying to pass a date from MySQL via PHP into JavaScript and instead of displaying the date correctly, it subtracts the date. How can I stop JavaScript from doing basic math? from html doc #1 &...
-1
votes
0answers
33 views

Datetime symfony to timestamp

I have to change my code from : $date=date ("Y-m-d", strtotime('+7 day', strtotime('NOW') )); to : $date=date ("Y-m-d", strtotime('+7 day', $form->get('dataSpesa') )); where with $form->get('...
0
votes
0answers
26 views

How to show different hours and minutes in a TableView (time zones project)

I'm trying to build a "time zones" app to consolidate my tableViews and Swift skills, however I encountered a problem. I used a dictionary to store the city's name (as the key) and the difference in ...
1
vote
2answers
26 views

python read_csv pandas parse column with format like 1990M01 to a montly date format

I have a CSV file like that obs , yr30 , tbill3m , ret3m 1990M01 , 7.98 , 7.8 , 0.028205 1990M02 , 8.44 , 8.02 , 0.007481 1990M03 , 8.61 , 8.08 , -0.003713 I try to import it like that data = ...
2
votes
3answers
64 views

When using .compareTo to compare dates, why doesn't it take Months into account? [duplicate]

I'm displaying certain dates from an ArrayList and using a formatter to shorten the date to "dd/MM" but when I compare the dates it doesn't work for the months. e.g. 17/08 IS before 19/08, 21/08 IS ...
4
votes
1answer
36 views

Ggplot minor gridlines not showing when they coincide with (disabled) major gridlines

I created a graph plotting data by day of the year with an x-axis where the tick marks indicate the start of each month and the minor grid lines indicate the start of each week. I intentionally don'...
0
votes
2answers
13 views

What are some examples of leap year bugs?

A leap year bug is a code defect that creates a problematic, unintended outcome when executed within the context of a leap year, typically within the proleptic Gregorian calendar system. The last ...
0
votes
3answers
49 views

How can I show date and time in the following format: “Saturday 30 April 2011, 12:05”?

I have to do an exercise on dates and times in Javascript. This is the text of the exercise: Write instructions that allow you to view (with the document.write () method) the current date and time in ...
0
votes
1answer
33 views

Showing this year and last year's data in one row in PostgreSQL

I have a table of sales grouped by week. I want to write a query that creates a new table giving the sales of the week in question AND the sales of that item from this time last year, but my attempts ...
0
votes
0answers
45 views

How to fix an IF Statement error in PHP where it get into the first one only? [on hold]

I'm doing a program where inserting some dates (start and end of a contract work), it gaves you what to use for calculating payments. I've wrote this PHP code to do all the comparisons and then give ...
0
votes
2answers
22 views

What data type should a date be set to and why?

I was trying to assign a date to a variable. I tried: Dim DateEnd As Date DateEnd = 7 / 21 / 2019 This didn't work... So I tried: Dim DateEnd As Date DateEnd = Now This works which meant that I am ...
2
votes
1answer
31 views

Messy Excel Dates to propper Python Pandas Date

I have a column in a Pandas Dataframe, called 'Excel_Date'. This column data looks like this: Excel_Date Before Q1 2018 Before Q1 2014 Before Q4 2018 42457 42457 42520 nan nan The column's dtype('O'...
0
votes
0answers
19 views

Time Series Line plot out of order with plotly R with column as Date type

So due to some constraints, I am attempting to recreate some ggplot2 plots with plotly. When I try to create a time-series line graph, the line connects the points out of order I have looked into the ...
3
votes
2answers
41 views

Expand rows by date range having start and end in Pandas

I'm working with a data set containing information on a phenomenon occurring during some time frames. I am given the start and end time of the event and its severity, as well as some other information....
0
votes
2answers
55 views

How to combine date object and time object into DateTime object and store in google sheet as DateTime object

I have a date object and a time object that I want to combine into a datetime object, not as a string but as a datetime object that I can store to later test against other datetime objects. All ...
0
votes
0answers
19 views

How can I get dates and hours of full day when data is not available? [duplicate]

I have some missing date and this cause that my dataframe is lacking. Date Buy 2019-08-09 00:00:00 1.9 2019-08-09 01:00:00 ...
0
votes
1answer
29 views

How to read “Date” value from “Excel” and send that value into “Date picker” using “Selenium WebDriver”

I used an excel sheet with "Date" as the cell type, in format dd-mm-yyyy In selenium code i used below code String value = String.valueOf(sheet.getRow(1).getCell(1).getDateCellValue()) driver....