Stack Overflow
Stack Overflow

Questions tagged [weekend]

117 questions
0
votes
1 answer

Javscript Function to return Weekend

I'm new to javascript, i'm trying to make a function to every time that a date is Saturday/Sunday, it will return 'weekend' instead of the day... The current function (i === 6) is returning the 6th day of each month. function weekend(i) { if (i…
M. M.
  • 11
  • 3
0
votes
0 answers

How to find weekends for various users in a global sales data?

I have a global sales data for various users. Following is an example:- Dates UserId SalesQuantity 2020-01-01 01:00:00 101 2000 2020-01-01 02:00:00 101 5000 2020-01-01 01:00:00 102 0 2020-01-01 02:00:00 102 …
Anil Thadani
  • 13
  • 3
0
votes
2 answers

Subtracting 3 days from date

I want to calculate a reminderDate by subtracting 3 days from it. However, if the resulting date falls on a Saturday or Sunday, it should give the date of the Friday falls on a Friday, it should give the date of Thursday For example Exchange Date …
stepbysteptomathpro
  • 455
  • 1
  • 7
  • 16
0
votes
1 answer

Trying to calculate a difference in dates, while excluding weekends - R-studio

IT_tickets[,"ticket_age"] <- NA {R aging_count for Tasks} IT_tickets$ticket_age[c(all_tasks)] <- difftime(IT_tickets$closed_at_date[c(all_tasks)], IT_tickets$sys_created_date[c(all_tasks)], units = "days") I have this column called "ticket age" in…
Enzo Tadeo
  • 1
  • 2
0
votes
1 answer

Only get rows based on flag for weekend / weekday / both

I have a whole bunch of tariffs, some work on weekends, some work on weekdays some on both. Sometimes I'll be querying on NOW() but sometimes I'll be querying on datetime column. id | Weekday | Weekend | Price 1 | 1 | 0 | 0.04 2…
Rudiger
  • 6,749
  • 13
  • 51
  • 102
0
votes
1 answer

PowerBI - conditional formatting for highlighting weekends

I have a data table matrix in power bi showing Dates in Rows and hours in columns and count of customers against them as values. i wanted to highlight all rows of thursday, friday and saturday, so that weekend figures can be compared. Need help in…
Rajesh Iyer
  • 1
  • 3
0
votes
1 answer

Python Business Days within loop

I am trying to loop through a dataframe, the dataframe has two columns, both with datetime variables inside. I am trying to loop through this data base and produce a new column with the count of business days between the two dates.I have tried using…
KieranC97
  • 47
  • 5
0
votes
1 answer

Extract weekend days from date

I have date field and from that date field i am trying to extract only weekends i.e. in my case Saturday and Sunday is weekend. So how can i extract weekends from date? If below dates are in weekend then should be like this: Date day …
Bakhtawar Ashiq
  • 63
  • 1
  • 9
0
votes
2 answers

I have trouble with taking away the weekend in my code

I'm making a site page for school where a person can put in two dates: day started working for company day stopped working for company (when the contract ends) these days are filled in via the format MM-DD-YYYY When a person fills in a start date…
Luuk S
  • 13
  • 6
0
votes
1 answer

Is there an SSRS expression for calculating difference between two days excluding weekends, Saturday and Sunday?

I'm able to calculate date difference between two dates, however, its include all weekends. But I need difference excluding weekends like Saturday and Sunday. I am using below expression: =DateDiff("d", Fields!StartDate.Value,Fields!EndDate.Value)
Mohsin A.
  • 153
  • 2
  • 18
0
votes
1 answer

Find weekly and weekend average sales of a month

I'm trying to compare average sales of a weekend and weekday in python. Suppose I have a dataset Order Date Units Sold day_week 2017-07-01 100 Sat 2017-07-02 100 Sun 2017-07-03 90 Mon 2017-07-04 90 Tue 2017-07-05 90 Wed 2017-07-06 90 …
Kanika Singhal
  • 253
  • 1
  • 2
  • 10
0
votes
1 answer

Skipping weekends with Highcharts Gantt

I am looking for a way to skip weekends while using date-time xAxis with Highcharts Gantt. I have read a few posts about the xAxis.ordinal option for HighStock but I am using HighCharts Also, I would need to stick to date-time because I plan on…
DixiPoowa
  • 133
  • 12
0
votes
1 answer

Teradata: count number of weekends between two timestamps

I would like to count the number of weekends between two timestamps. My data sits in Teradata. I can't use a raw time difference because starting points will vary.
NLR
  • 1,714
  • 2
  • 11
  • 21
0
votes
1 answer

How to update a date weekly?

I'm implementing a countdown to the Saturday- day of each week, I want that when the counter reaches zero (Saturday) it will be activated again for the next Saturday. But I have no idea about how to update the date each week. The code I am using is…
Jim Michael Nowell
  • 53
  • 9
0
votes
1 answer

Get days between start and end date without weekend and + - span

now I have a new question. I need to calcualte the timespan between two dates. My problem is: Weekends have to be excluded and the timespan can be minus or plus. For example: Planed delivery Real delivery 2017-11-28 2018-11-17 2016-05-10 …
Torte
  • 13
  • 4
1 2 3 4
5
6 7 8