Stack Overflow
Stack Overflow

Questions tagged [weekend]

117 questions
1
vote
2 answers

Google Data Studio Ignores Saturday and Sunday when Indicating Yesterday in Custom Date Filter Default Range

I am creating a report in Google Data Studio which pulls numerous days-worth of data; however, I want the report's date filter to default the initial presentation data to ONLY display the previous BUSINESS DAY's data. I can set the default date…
Vector7
  • 107
  • 1
  • 7
1
vote
0 answers

How to Tell R What Day of the week should be the start or end day of the week?

When converting a daily XTS object in R to weekly using to.weekly() function, The weekly XTS object has week-endings on "Sunday". How is it possible to set the week-endings to be on "Saturday" instead?
devmaster2
  • 47
  • 1
  • 5
1
vote
2 answers

Calculate seconds between 2 timestamps in R excluding weekends

If I have a dataframe with 2 columns which are YMD HMS, how do I calculate the difference in seconds between the two excluding weekends? col 2 - col 1 = time in seconds; need to exclude the weekend seconds Dates1 <- as.POSIXct("2011-01-30 12:00:00")…
user_1771
  • 47
  • 7
1
vote
3 answers

Determine whether a date falls on weekend in Angular/Javascript

Given a date in yyyy-mm-dd format, how can I determine whether a date falls in the weekend in Angular/Javascript? $scope.isWeekend= function(){ $scope.date = '2018-05-13'; /* if (day(date)=='saturday' || day(date)=='sunday') { */ alert(""); …
user21
  • 1,261
  • 5
  • 20
  • 41
1
vote
1 answer

SAS: plotting dates excluding weekends using PROC SGPLOT

I'm running SAS 9.3, and I'm trying to create a plot using PROC SGPLOT that (1) shows only dates contained in my dataset as consecutive dates (ie, excluding weekends and holidays), while (2) displaying usable information on the XAXIS (eg, the first…
Eric
  • 53
  • 1
  • 5
1
vote
1 answer

Divide Monthly Working Hours into Weekly Hours - SQL Server

I have a requirement where I have to generate a report using the below monthly data for each employee. The report runs on 1st day of every month and provides data till 1st of day of last month. The requirement is to divide this data in weekly data.…
ankur jain
  • 67
  • 1
  • 10
1
vote
0 answers

R survival time dependent covariate is weekend: how to split

I'm looking at the effect the weekend may have on an individual's survival and so I'm trying to convert my data into a time-dependent structure with one row per interval. It will probably be a Cox PH model with DschDT (Discharge Date) as the…
user3602585
  • 13
  • 3
1
vote
1 answer

EXCEL-Count weekend days within a number of dates within Countifs with overlap

I have to determine per specialty the total percentage of surgeries that started outside the regular working hours or in weekends. This is what I have so far: =COUNTIFS(Table1[Start surgery];">17:00")+COUNTIFS(Table1[Start…
user3755730
  • 27
  • 1
  • 3
1
vote
1 answer

PHP Business days stop at weekends create a new start date on monday

Hi already i'm using this code from another question - which adds two extra days to endday in the case of weekends function add_business_days($startdate,$buisnessdays,$holidays,$dateformat){ $i=1; $dayx = strtotime($startdate); while($i <…
Ezugo C
  • 59
  • 1
  • 4
1
vote
1 answer

offset for weekend days using mod

I have a .NET console app that needs to run on the 1st, 5th, 10th, 15th, 20th, and 25th of each month. Depending on which date it runs, the app sends out a different type of email. I want to adjust the app so that if one of those dates is on the…
dotnetnoob
  • 73
  • 8
1
vote
3 answers

Count days between two dates excluding weekends

How can I find the difference between two dates in DB2 (excluding weekends)? Are there any functions that will do this in DB2? Or do I need to write a query myself?
Ravikumar
  • 11
  • 2
  • 4
1
vote
1 answer

Calculations excluding weekends

I am trying to make a holiday booking application and it runs of a JQuery UI calendar. the star and end date they select are passed to SQL where it puts the holiday into the requested table. the only problem is if i put a start and an end date in,…
Kieranmv95
  • 828
  • 4
  • 14
  • 31
1
vote
3 answers

change the Date if its Weekend with C# wpf

I write a Datepicker in wpf c#. Its let the selected day always of the end of the Month and I need that my Application check if the day is Saturday so its return the selectedday-2 and if it is Sunday than day-1 but this weekend function it doesn't…
user2054112
  • 23
  • 6
1
vote
1 answer

How can I determine what days are the weekend?

Using the .NET CultureInfo, how can I determine if a DateTime is in the weekend? The weekend is Saturday/Sunday in most of the world, but it's Friday/Saturday in Israel and the Muslim countries. Anyone got a program that handles this? The question…
David Thielen
  • 28,723
  • 34
  • 119
  • 193
1
vote
0 answers

Filtering out weekend days from time series line chart in D3.js

I have multi-year, daily dataset that looks like this: date close 2013-09-17 178 2013-09-16 185 2013-09-15 20 2013-09-14 10 2013-09-13 190 2013-09-12 157 2013-09-11 150 2013-09-10 …
Daniel Romero
  • 317
  • 1
  • 4
  • 11
1 2
3
4 5 6 7 8