Most voted "date" questions
Date is the representation of a specific point in a calendar, usually represented by a day, month and year, the values of which may vary according to the culture and calendar used.
Learn more…887 questions
Sort by count of
-
0
votes0
answers13
viewsIs it possible to reference an alias in Mysql and use its field value?
I have the following situation: An electronic point in mysql and working on a query that makes several calculations with dates and times. select nome_colaborador, date_format(data_registro, "%d %M…
-
0
votes0
answers47
viewsFunction to calculate higher percentage of hires per region in R
Hello, I am trying to make a function that returns the highest percentage (Taxas_in) of hires in a region (Local), and the output would be the sector (Activity) and the respective rate with the…
-
0
votes0
answers3
viewsSort date column on pandas
Good afternoon Guys, I need your help. Why when I use the df1['Delivery'] = pd.to_datetime(df1['Delivery']) command and export to excel via the df1.to_excel('Production 1.xlsx', index=False) my…
dateasked 3 years, 4 months ago Bruno Souza 1 -
0
votes1
answer33
viewsHow to create bar graph with 2 different y axes and the same x axis?
I’m trying to plot a bar graph with 2 different y axes and the same x-axis. The closest I’ve come to success with the following code: fig = plt.figure() # Create matplotlib figure ax =…
-
0
votes0
answers29
viewsfilter a Json by date in javascript
I need to create the function that returns the expired boletos in relation to "data_expiration" and "30-07-2021" but I need to create this without changing the rest of the code beyond the existing…
-
0
votes1
answer31
viewsHow to check the latest registration for the latest?
have the following query sql - code below - and I would like to increment in it a "filter" of the most recent Insert so that the query is the latest pro Insert. $sql = " select ec.id_contrato,…
-
0
votes1
answer28
viewsTextinput value does not change - React Native
So I’m taking these values in Asyncstorage and they come from my database, so far so good, I take the const’s and I play in them the values I pulled. but I need to be able to edit this by the text…
-
0
votes0
answers24
viewsSum date in a form field
I need to get the date sum from the integer number indicated in the form field, and display it in the second date field in a process form. I tried the following: var dias =…
-
0
votes0
answers7
viewsChange the start and end date reference of a month in Power BI
I need to create filters in Power BI Dashboard in which the month of August, for example, starts on the 20th of July (previous month) and ends on the 19th of August. This should be done for all…
-
-1
votes1
answer2580
viewsPick up show and change Time / Date
Good morning! I would like to take the time of mobile play on the screen so the user can change and save the time the user chooses and the same thing for the date. example to do like the alarm clock…
-
-1
votes1
answer250
viewsCheck events that occurred in a given period of time
I need to register the following event in my program: Players who kill 5 times during the 1 minute break will win a prize. My class mapping is as follows: public class Game { private String name;…
-
-1
votes1
answer149
viewsPhp missing dates 10 days
I have a question and would like to know if it is possible in this code instead of showing expired dates show missing dates 10 days to expire. if(!empty($row[10]) AND ($row[11] < time() ||…
-
-1
votes1
answer635
viewsHow to insert timestamp value into a Mysql table?
I am receiving a timestamp value from a request, and would like to store this value in my bank, however I want the column to interpret it correctly. The value is 1416178487. And using the function…
-
-1
votes1
answer290
viewsCampo Jtextfield
How to convert a component JTextField for type Date? How to do research? How to create a query for the bank by returning a list of orders according to a date range? Follows the code currently used:…
-
-1
votes1
answer629
viewsFormat date from variable with php
I have the variable below and want to format to the Brazilian standard (20/01/2015) using PHP. $data = Sun Jan 10 00:00:00 CST 2016
-
-1
votes1
answer67
viewsChange in GIT log
I would like to change my GIT server log using a hook. The situation is this, when someone gives a commit and the local machine is with the wrong date, in the log appears the time of the local…
-
-1
votes1
answer53
viewsProblem getting date from screen
I have a small error when picking a jtextfield date, error occurs: String cannot be converted to date Follows my code: public TelaControle getVendaFromTela() throws ParseException { Venda vDaTela =…
-
-1
votes1
answer112
viewsSearch by date does not work
I am trying to do a search in the mysql database doing a filter by date and is not bringing any results. On the screen below I was able to search for the other criteria This is the code that’s doing…
-
-1
votes1
answer107
viewsPython Handle API
I want to use the following API response: https://cex.io/api/ohlcv/hd/20160228/BTC/USD Then I want to divide it into blocks like this: [1456617600,434.3867,434.3867,433.781,433.781,4.15450000] and…
-
-1
votes2
answers300
viewsHow to create a data frame of a database based on the difference of two dates in a column of another categorical variable in the R software
I have the following database as an example and the result I expect: In the case the values in the new dataframe refer to days, which is the difference of the last date of a category from the first…
-
-1
votes1
answer1785
viewsValidate date of birth, so you can not register under 18 years (Javascript)
I have a field called txtdata_nasc of the date type. I need the user not to be able to type a date that makes him less than 18 years old, but also that he cannot be of an absurd age, such as 100…
-
-1
votes1
answer76
viewsImplementing function of type Month
Good morning guys blz? was implementing a Month type function that returns Month I tried to use static_cast to convert to Month type but from conversion errors to same. The program is this below:…
-
-1
votes3
answers246
viewsComparison of dates in PHP
I’m doing this code to compare the current date with the date I entered into the form, I used this logic to do this, but apparently it’s not working. What could be wrong? <?php $data =…
-
-1
votes1
answer611
viewsRenaming files with date in python
I would like to rename files from one folder and send them to another one, but I wanted it to contain the date or at least put a number after the name if I already had one. The code is this below,…
-
-1
votes2
answers128
viewsDate balance in mysql
I have a table requests and would like to return to the following situation. select all orders of a current month idClient by summing the values of the same. type select * from pedidos where…
-
-1
votes3
answers187
viewsComparison of dates in Javascript
Hello I need to compare the current date with the one typed by the user but the seconds prevent this verification: var data_publicacao = new Date($('#frm-data').val()); console.log(data_publicacao);…
-
-1
votes1
answer344
viewsProblem with setlocale on the web server
I have an online site that is set the time zone for America/Sao_paulo and using setlocale for Portuguese, but even so the site where I have functions strtime, give the text in English, I tried to…
-
-1
votes1
answer353
viewsConvert Brazilian to American date to parse for a Date object
I’m making an application that reads an html page and gets some information, among them a date. This date is in Portuguese, in the following format: "23 March 2019". I wonder if you have any way to…
-
-1
votes1
answer702
viewsHow to rename DEFAULT in the <input type ="date" > tag
I’m putting in a form one input type=date , with this he returns to me mm/dd/aaaa. I would like that, instead of appearing this, appeared anything else that I typed, as for example "Initial Date".…
-
-1
votes1
answer224
viewsWork with hour and minute
I would like to make a code that takes time and minute so that I can work with a schedule for the execution of an action, example: var inserirProgramAtual = document.getElementById("CBNestudio"); if…
-
-1
votes1
answer810
viewsSearch date and time range PHP MYSQL
Assuming there is an ex date range: 2019-02-22 and 2019-02-26 I need to search the database by date and time (I need to extract the value by specific date and time, for example only from 05:00 to…
-
-1
votes1
answer30
viewsPlace date command inside e-mail
I own a script, and would like it to send an email to users informing the time that the same was executed. Example: $script_deploy.sh # Envio de e-mail aviso deploy echo "=> Envio de e-mail para…
-
-1
votes2
answers184
viewsDiscover time interval
I’m trying to figure out the time interval between two strings with the strtotime. One has the complete temple and the other varies from minutes to hours, the problem is that when there are minutes,…
-
-1
votes1
answer246
viewsSubtract PHP date and time
I looked it up online and couldn’t find anything to help me solve this problem. I need to do the following, get a date/time informed by the system and decrease it by 5 hours. Example: 2019-08-29…
-
-1
votes1
answer53
viewsI need to find the duplicates inside a CSV and count them
I am trying to read the amount of repetitions in column A and B of a CSV and see the amount of times A and B are equal as the example below: input: [email protected] |…
-
-1
votes1
answer111
viewsPHP with PDO returns full SQL date
I have a PHP application that reads data from tables that can be SQL or Postgres. When I started using PDO instead of mssql, the SQL data fields return ex: 'Nov 29 2019 12:00:00:AM'. If you query…
-
-1
votes1
answer175
viewsFill array table
Hello, I’m developing a web project but I can’t get the desired result. I have a php file that returns me an array of vehicles and my Index calls this file to get this array through ajax. When…
-
-1
votes1
answer279
viewsHow to calculate the current and future date and receive the difference in days
I’m using Moment.js to do date calculations, thinking about it I did this function below to make the current date calculation with the date of birth: onCalcularData(date: any): number { return…
-
-1
votes1
answer904
viewsFormat Firebird SQL data dd/mm/yyyy
How to convert a date to dd/mm/yyyy format in Firebird ? I tried some ways to convert 2020/06/22 to format but always come out in YYYY/MM/DD format: CONVERT(DATE, DATA, 103) AS "Data"…
-
-1
votes1
answer46
viewsDate manipulation using dplyr and lubridate
I have a date frame whose columns have dates (%Y/%m/%d), times and averages per hour over 4 months (01/01/2020 - 01/04/2020). I wonder how I could calculate the average of these hourly values, for…
-
-1
votes1
answer171
viewsPrestashop error "Cannot select any Valid SQL engine. at line 302 in file classes/db/Db.php"
Good morning, I had a problem with the files of the server in which they were all deleted, however I had backup of the whole site, since this was done a data restore, which happened in normal, but…
-
-1
votes1
answer47
viewsSelect in php recognizes only one variable
I need to search the database for dates and compare them to the dates generated by a for. If they’re the same, they turn red. I already got the numbers for one Select and store them in one array…
-
-1
votes1
answer29
viewsData Dynamic Azure Data Factory
good afternoon! I’m doing a project in which I upload data from SAP to my SQL, via Azure Data Factory. It turns out I need to have a dynamic column Partition, by date: I need, for example, to take…
-
-1
votes1
answer48
viewsHow to compare dates?
I created an NN/NN/NNNN mask in my editText to capture due date, without a calendar, all done in edt. Then I used Simpledateformat to capture the current system date. I made a comparison with the…
-
-1
votes0
answers18
viewsTo restrict only a specific date in a type="date" field
Hello. Good morning. I am using a date field to allow users to select a day to reserve equipment, however, I would like that when the user opens the calendar, the dates already scheduled could not…
-
-1
votes1
answer40
viewsDate filter service range in holiday plan
Good evening friends, I have a scale of service in excel that is daily and I have a camp for departures ( vacation), I need to create a filter where only appear in such field professionals who are…
-
-1
votes1
answer42
viewsDifference between dates to find the number of days
Hello, friends. I have a code where I calculate the difference in days between two dates. I need to pass the variables to the object instance, but it only works if I put the string manually. (1)…
-
-1
votes2
answers440
viewsVBA reverses day with month in variables of type Date
Context: I have the following code that receives from the user a date: dataAtualDefault = Day(Date) & "/" & Month(Date) & "/" & Year(Date) dataInsercao = Application.InputBox("Data…
-
-1
votes1
answer668
viewsCondition in VBA if Date reported in Textbox is Higher or Lower
I have a macro for the Date that the user entered in Textbox, for minor that the date of a cell of a given row, I will make a change in the information of a column of this row. Sub test() Dim data…
-
-1
votes1
answer668
viewsCondition in VBA if Date reported in Textbox is Higher or Lower
I have a macro for the Date that the user entered in Textbox, for minor that the date of a cell of a given row, I will make a change in the information of a column of this row. Sub test() Dim data…