A day of the week. Used for questions related to programming problems that involve `weekday`: calculation, triggering an event, discovery of a specific day etc
Questions tagged [weekday]
462 questions
3
votes
2 answers
List of 3rd Wednesdays of each month
I'm trying to find the formula to automatically generate the Third Wednesday of Each month.I searched and found this:
=LOOKUP(A3,DATE(YEAR(A3),{0,3,6,9,12;3,6,9,12,15},22)-WEEKDAY(DATE(YEAR(A3),{0,3,6,9,12;3,6,9,12,15},4)))
Where my first…
evilrod
- 77
- 1
- 1
- 10
3
votes
2 answers
Using WEEKDAY function inside a COUNTIFS
I want to count the times John was in the blue room and it was a thursday. I played with COUNTIFS and WEEKDAY and checked the documentation.
I tried COUNTIFS with two conditions but got errors or 0 as a result.
Alawna
- 33
- 1
- 6
3
votes
1 answer
How do you get a dynamic 12 business day view in Postgresql?
Here is the code I currently have that gives me the last 12 days
SELECT *
FROM table
WHERE analysis_date >= current_date - interval '12' day;
analysis_date is the date column in the table. I understand why this isn't working because it's not…
mgtemp
- 248
- 3
- 11
3
votes
2 answers
Calculate previous week data in Teradata
How to calculate prior 7 days data (Sunday-Saturday of the previous week). on whatever day of week it is run it should always give Sunday-Saturday of the previous week.
thanks
user3438498
- 211
- 3
- 11
- 21
3
votes
4 answers
Extract day number from day string
Is it possible to extract an integer value from day names, i.e. "Mon", Tue", "Wed" with an SQL statement?
For example:
Mon = 1
Tue = 2
Wed = 3
mouthpiec
- 3,923
- 18
- 54
- 73
3
votes
3 answers
Python construct datetime having weekday with other time parameters
I need to construct datetime object from different parameters. For example, I get these parameters:
integer number from 0 to 6. This one indicates weekday.
hour and minutes in float format (from 0.0 to 24.0).
And then I know which week of the…
Andrius
- 19,658
- 37
- 143
- 243
3
votes
1 answer
Issue in getting Next Week value in button click android
I want to get next week value in button click so below is my code
OnCreate Method I declare Calender Object and print Current date
int WeekNumber;
Calendar mCalendar = Calendar.getInstance();
mCalendar.set(Calendar.DAY_OF_WEEK,…
Harshal Kalavadiya
- 2,412
- 4
- 38
- 71
3
votes
1 answer
GregorianCalendar returns wrong DAY_OF_WEEK in Java
This code:
Calendar calendar;
calendar = GregorianCalendar.getInstance();
calendar.set(year, month, day);
week_day = calendar.get(Calendar.DAY_OF_WEEK);
returns wrong value.
For example
year=2013, month=3, day=31
returns the same value…
user2224076
- 63
- 6
3
votes
2 answers
jQuery datepicker start date interval not showing
I use jQuery datepicker for showing users available days and wants to disable and mark red busy days. I use for this beforeShowDay datepicker option:
beforeShowDay: function(date) {
var cssClass = '';
for (var i=0; i <…
Dmytro Zarezenko
- 10,526
- 11
- 62
- 104
3
votes
3 answers
Number of Tuesdays in the current month in objective c
I'm looking for a way to calculate the number of Tuesdays in the current month in Objective C.
For example if the code ran today (July 16, 2012) it would ouput 5 because there are 5 Tuesdays in the month of July in 2012 (the 3rd, 10th, 17th, 24th,…
user1530460
- 80
- 7
2
votes
5 answers
Get string representation of a sql DateTime day
Let's say i have a sql datetime of '1 May 2009' or '12 May 2009'.
Is there any built in sql function / operation i can perform on the dates above to return the string representation of the DAY of the date?
So for '1 May 2009' i'll get "Friday" as…
CODES_ONLY
- 181
- 2
- 11
2
votes
1 answer
Check day of week in Android
I want to check if the current day of the week is Sunday or not. How can I find it out? I am using this in alarm activity. Please help me. I want to setup an alarm which does not work on Sunday. Thanks in advance.
picaso
- 713
- 2
- 14
- 26
2
votes
1 answer
2
votes
1 answer
Monday as first day of week for WeekArchiveView
How do I convince WeekArchiveView that Monday is the first day of week?
Dan Abramov
- 264,556
- 84
- 409
- 511
2
votes
2 answers
Is there an R package that will handle POSIX objects and return the nth N-day of the week?
I have written a function which, when provided a range of dates, the name of a particular day of the week and the occurrence of that day in a given month (for instance, the second Friday of each month) will return the corresponding date. However, it…
Josh
- 361
- 2
- 10