Stack Overflow
Stack Overflow

Questions tagged [weekend]

117 questions
0
votes
1 answer

NSdate range total removing weekends Swift

Im making a works holiday/vacation day booking app. I have an extension that works out the total number of days between 2 NSDates, it works great, but I do not know how to remove all weekend days from the total. Can you help please? extension…
ThundercatChris
  • 481
  • 6
  • 25
0
votes
2 answers

Git - create statistics about working on weekend

What would you recommend for creating statistics about working on weekends? I tried some tools, and I like git timecard the most but I have a problem with it : in the background it uses git log, and I receive this warning : "warning: Log for '...'…
thorax
  • 574
  • 1
  • 5
  • 16
0
votes
1 answer

Business Week Group in SQL (instead of calendar week)

My requirement is that I want to find business-week-ending (not the calender week) given a DATE column from the sales table in MSSQL. Using different techniques I was able to find the [Calender] week-endings (and week-starting) dates corresponding…
Honda
  • 1
  • 1
0
votes
1 answer

How to put Weekdays and Weekends on the x-axis of a graph - Excel

I have a hourly data of a entire week in excel, and I want to plot it! But when I do so, in the x-axis appears the hours of the week (i.e, from 1 to 168), as it was expected. But I would prefer that it would just appear the days of the week, i.e.,…
PingP
  • 17
  • 5
0
votes
2 answers

TSQL - SQL 2008 - Across a date range (Start Date to End Date) is it possible to break this range into seperate rows by (and exluding) weekends?

I apologize for the poorly worded title, I have been given a task beyond my limited skillset and was hoping someone might help. We have employees who have 24/7 schedules for booking work and field assignments (over weekends as well) but this does…
Hiigara
  • 9
  • 1
0
votes
1 answer

How to exclude weekend days - Oracle count SQL

SELECT trunc(to_date(substr(CLOSEDATE,1,10), 'DD-MM-YY')), substr(FIXCODE, 1, 4), COUNT(*) FROM opencall WHERE (opencall.status > 15 OR opencall.status = 6) AND FIXCODE like 'HPS0%' AND trunc(to_date(substr(CLOSEDATE,1,10),…
Anthony Stewart
  • 25
  • 1
  • 6
0
votes
2 answers

Counting the age of an item in weekdays only

I've been trying to count the age of something in weekdays. I've tried the method detailed in this question, Given a date range how to calculate the number of weekends partially or wholly within that range? but it doesn't seem to fit my usecase. An…
David Yell
  • 11,756
  • 13
  • 61
  • 100
0
votes
1 answer

Skip weekends Business day tasks NetSuite

Using NetSuite, I am trying to automate the creation of monthly tasks. These tasks will fall on the last day of the month, a day before, and 1,2,3,4,5 days after the last day of the month. But, the tasks can't be due on a weekend, only business…
Jess Anastasio
  • 687
  • 5
  • 18
  • 26
0
votes
2 answers

SQL Server: I need to manipulate data differently on weekends than weekdays

I have a SQL Server table that has production running times for different pieces of equipment organized by date and shift. For example: Date, Shift, Running Hours 7/11/14, 1, 4.2 My problem is that on weekdays, there are 3 eight hour shifts…
d.munky
  • 3
  • 1
0
votes
1 answer

Trying to fetch COUNT() on weekday and weekend

I have a table that contains a column (created) that stores a unix timestamp when that item has been created. Now I want to COUNT() all items that have been created on a weekday (Monday to Friday), compared to all items that have been created on the…
Gottlieb Notschnabel
  • 9,408
  • 18
  • 74
  • 116
0
votes
1 answer

Exclude weekends from calculated-field date using expression-builder MS Access

i have two fields in my access db table. One contains dates [D] and the other contains numbers [N]. I have created a calculated field that stores ( [D] - [N] ) dates. my problem is that i would like to exclude weekends from the dates stored in the…
user3041384
  • 75
  • 2
  • 4
  • 11
0
votes
2 answers

If actual date is Friday, also show rows at saturday and sunday Oracle DB

Normally I only show a record, if the actual date is one year later than the date in the database. How can I check if that day is a friday and then show also the records with the date of the saturday or sunday? For example: Friday the 13th before…
Christian
  • 22,585
  • 9
  • 80
  • 106
0
votes
2 answers

jquery datepicker ui - weeknds only

see there is a few post for this but tied but they don't seem to work. var noWeekend = jQuery.datepicker.noWeekends(date); currently my code does this and makes the weekends in active, but I would like it to do the opposite and make only the…
LeBlaireau
  • 17,133
  • 33
  • 112
  • 192
0
votes
0 answers

Elapsed time between 2 dates, excluding weekend in SQL

How can I calculate the time between two timestamps in MS SQL Server excluding any weekends? For example, from 2013-05-03 17:00:00 to 2013-05-06 09:00:00 should give me 16 hours. (Better if it's a function which I can call fn(hours, stdt, enddt).)
Hing-Lun Ma
  • 83
  • 1
  • 1
  • 5
0
votes
2 answers

Getting Over Weekends in SQL

I am using SQL server 2008 and have a query that runs daily. Where [Order Date] = getdate()-1 I need a statement that will run Monday and sum the data for Friday, Saturday, and Sunday if that is even possible. Thanks!
jswan
  • 90
  • 7
1 2 3 4 5 6
7
8