Databases
StackOverflow2013
Postsdbo
PONeed to add days to a date, but exclude certain days from a calendar
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PONeed to add days to a date, but exclude certain days from a calendar
    primarykey
    data
    text
    <p>Working in Visual Studio with C#. I'm making a piece of software for a small office that captures lawsuits. Once a lawsuit is captured, the office has 15 days to send some documents to the tribunal. So deadLine is in 15 days.</p> <p>But if there is for example, and update (update1) to the lawsuit, the office now has a new deadLine to send update1 documents.</p> <p>So, deadLine for Capture is dd/MM/yyy Then, deadLine for update1 is dd/MM/yyyy</p> <p>But I need to exclude all non labor days, so the deadLines do not display any non labor days. Example:</p> <p>Capture: 15 days Update1: 5 days Update2: 10 days Update3: 7 days</p> <p>So, if I capture today, July 28 2011, 15 days should be added to the deadLine variable, which would be August 12, but I have to exclude non labor days from a calendar. For example August 12 2011.</p> <p>I've turned the DatePicker value to string, with format (dd/MM/yyyy), and I'm comparing it to a list of strings of non-valid days, with format (dd/MM/yyyy).</p> <p>And if the deadLine falls on one of these days, I convert deadLine to dateTime, add 1 day, until it does not fall on one of these days. Then save the final dateTime value as the new deadLine.</p> <p>Example:</p> <pre><code>string DeadLine; string NonValidDay001 = 12/08/2011; string NonValidDay001 = 15/08/2011; string NonValidDay001 = 19/08/2011; DeadLine = DatePicker01.Value.AddDays(15).ToString("dd/MM/yyyy"); while (DeadLine == NonValidDay001 | DeadLine == NonValidDay001 | DeadLine == NonValidDay001) { dateTime dt = Convert.toDateTime(DeadLine); dt.AddDays(1).ToString("dd/MM/yyyy"); DeadLine = dt; } </code></pre> <p>The problem I'm having is, it is not adding days to the dealine if deadline matches non-valid days.</p> <p>What I'm doing is not working in any way.</p> <p>Could anyone enlighten me please. (=</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USYushell
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PONeed to add days to a date, but exclude certain days from a calendar
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PONeed to add days to a date, but exclude certain days from a calendar
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODo you also want it to skip over labour days if the appear within the 15 days? (not just if the date 15 days from the start is a labour day)
      singulars
      1. PONeed to add days to a date, but exclude certain days from a calendar
      1. USGeorge Duckett
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload