Questions tagged [weekend]

117 questions
4
votes
1 answer

Mermaid Gantt exclude weekends from Axis

How do I exclude weekends in the visual output? (see circled area below). I would like to exclude weekends both in counting and visually. Is there a way to do that? Here is my code, gantt title blabla dateFormat YYYY-DD-MM axisFormat…
klaushipp
  • 75
  • 6
4
votes
1 answer

How to persist a bit field indicating a date is on a weekend?

I am trying to persist that a date is on a weekend in a table. ADD [IsWeekEnd] AS (CASE DATEPART(dw, GETDATE()) WHEN 1 THEN 1 WHEN 6 THEN 1 ELSE 0 END) PERSISTED ADD [IsWeekEnd] AS (CASE…
Chris Crowe
  • 333
  • 1
  • 9
3
votes
2 answers

sql oracle ignore holidays

I am using this code to calculate the difference between two dates ignoring weekends: SELECT To_date(SYSDATE) - To_date('01.07.2014', 'DD.MM.YYYY') - 2 * ( TRUNC(Next_day(To_date(SYSDATE) - 1, 'FRI')) - TRUNC(…
piguy
  • 516
  • 3
  • 10
  • 30
3
votes
4 answers

Subtract days from a date field(mm/dd/yyy) excluding weekends jquery

How can I subtract days from a date field? Example: Date Value is 03/10/2014 (mm/dd/yy), I want to be able to subtract 6 weedays from it to get 03/03/2014 Can someone please help me get this. Fiddle: to add 6 weekdays and disable all previous date…
BetRob
  • 251
  • 1
  • 7
  • 12
3
votes
6 answers

Javascript: find beginning of Advent weeks each year

I have created the following code (which works) to print something different based on the weeks of a specified month: