A day is a unit of time which is equal to an interval of 24 hours. It may be used for example for measuring the length of a period (see also period tag). For questions about dates or day of week rather consider tags like date or dayofweek.
Questions tagged [days]
554 questions
-2
votes
2 answers
Why does every month return 31?
My code runs fine but returns 31 days for all months if there is a spelling error. How can I correct this?
month= input ("Enter month : ")
days = 31
if month == "April" or month == "June" or month == "September" or month == "November" :
days =…
Jeff Hust
- 11
- 1
-2
votes
4 answers
How to count days between to dates
So I would like to count how many days between two datepickers.
So I tried to make two array but it didnt work
any Ideas?
Here my date pickers
Aviv lev ari
- 1
- 1
-2
votes
1 answer
How to find number of days in a given month from a date in Python
I have a Python dataframe with one column with dates like below:
Date:
2018-10-19
2018-10-20
2018-10-21
(...)
2019-01-31
2019-02-01
Any ideas on how to add an additional column with the number of days in a month, having something like:
Date …
Jo Costa
- 421
- 1
- 6
- 17
-2
votes
3 answers
Difference between 2 dates in days and in double
I am working on an app and i need to get the difference between the actual date and a date inserted by the user, in days and in double.
Any idea on how to make this? I've tried some things but without success.
YUCA
- 1
- 1
-2
votes
1 answer
SQL performing day difference by matching value
My goal is to get the duration when the 1st OLD or 1st NEW status reaches to the 1st END. For example: Table1
ID Day STATUS
111 1 NEW
111 2 NEW
111 3 OLD
111 4 END
111 5 END
112 1 OLD
112 2 OLD
112 3 NEW
112 4 …
TylerNG
- 919
- 2
- 9
- 23
-2
votes
1 answer
In Excel, how can I calculate leave days and hours of personnel in the office?
In the office, I need to calculate leave days and leave hours of personnel.
In our country, each employee can use 2.5 leave days each month.
so, I need to calculate his leave days and also leave hours to prevent leaving more than 2.5 days per…
shaghayegh hamedani
- 79
- 1
- 6
-2
votes
1 answer
Number of sunday, monday, etc before current date in current month using Mysql Query
I have one date field inside table, and i want to find the number of sunday's before current date in current month using mysql.
How can i get the number of sunday, monday, etc before current date in current month ?
Kausha Mehta
- 2,828
- 2
- 20
- 31
-2
votes
3 answers
Add +7days to current date?
$tmp['y'] = ($PDF->PageHeight*70.5)/100;
$tmp['x'] = ($PDF->PageWidth*49.5)/100;
$PDF->ShowTextAt($tmp['x'], $tmp['y'], date('m/d/Y'));
How would i add 7days to this current date code?
-2
votes
1 answer
Usaco. Friday the thirteen. What is wrong with my code?
I've made a program for the USACO task and now I just can't figure out why I'm getting the bad answer, I've been thinking why for a long time and still didn't figure it out. What could be wrong?
The task is to count the number of times the 13th…
user3216599
- 1
- 1
-2
votes
3 answers
Days between current date and a numeric field stored as DDMMYY
I have a field of dates stored as DDDDMMYY and want to calculate the number of days between this date and the current date.
I am using WINSQL and DB2.
I get a result using the below…
user2990696
- 1
- 2
-3
votes
1 answer
Need to count days open in a month based on multiple openings and closings
I'm trying to count the number of days a given location is open in a month based on multiple re-openings and re-closings.
-3
votes
1 answer
T-sql how to add days when no data in date range
I need a query and it can only be a select statement, no cte's, functions etc, due to limitations of the reporting solution i am using, to fill days when selecting a date range and there is no values for some of the days, this is to show a trend in…
Alberto Caeiro
- 1
- 4
-3
votes
1 answer
Is there a way to count days INSIDE a range of dates?
I'm quite a beginner on VB/SQL, I just began my learning few months ago, but I can understand the logic of algorithms as I used to do some Excel VBA .
I'm actually designing a database where I can (wish to) follow up every colleague's activity…
Mao Guenn
- 3
- 3
-3
votes
1 answer
Hello, i need please that the day selcted automatic on the real day today and also i need that the previous days will be blocked to select
i need please that the day selcted automatic on the real day today and also i need that the previous days will be blocked to select.for example today is Wednesday, so i need that the selected day will be Wednesday and Tuesday, Monday and Sunday will…
emanuel
- 19
- 1
- 6
-3
votes
1 answer
Date format to Day
Currently, I have a list of Date and time (2017-12-13 01:05:44) in my dataframe.
Can anyone please help me to create a new column ('Day') in my dataframe, with a list of days corresponding to my date columns.
*Can Ignore the time.
For example, the…
123cremepie
- 339
- 1
- 3
- 5