Skip to main content
added 361 characters in body
Source Link
Allan
  • 104.4k
  • 33
  • 206
  • 470

No. You can't create a recurrence for this granular of a rule set.

  • I'm paid every month;
  • I'm paid always on the last possible day before the 28th day of the month;
  • I'm paid always on a working day.

So, to simplify it, you're paid the 27th of every month unless it's a weekend or holiday, then you're paid the previous workday.

Your options are as follows:

  • Schedule a year or two of a monthly recurrences for the 27th then go through the next 12/24 entries and manually fix the ones that fall on a weekend or holiday. This is probably the quickest and most effective method because you can quickly scan your calendar for conflicts.

    Using the calendar below, you can find only 3 instances where the 27th falls on a weekend in less than 30 seconds. Easter being a 4th entry is also simple to modify. It's simply not efficient to code thisthese one-offs.

  • Create a CSV (Excel) file of your pay periods and convert them to .ics.

You're finding hard coded calendars with no logic because it's far easier to make the single change manually than to write the logic for it. Your payroll admin also processes these anomalous events manually. The problem with trying to automate this is...

  1. holiday events vary too much from culture to culture
  2. holiday events in calendars aren't "calculated""calculated;" they're event entries like all elseevery other event entry (team meeting, dentist appointment, parent/teacher conference, etc.)
  3. holiday events are not all equal. Not all banks/companies will observe all holidays (close).

You could create the code using an opensource ics library to generate the .ics files your particular organization, but you're not going to find this recurrence pattern available in the calendar apps.

 

enter image description here2021 Yearly Calendar View

No. You can't create a recurrence for this granular of a rule set.

  • I'm paid every month;
  • I'm paid always on the last possible day before the 28th day of the month;
  • I'm paid always on a working day.

So, to simplify it, you're paid the 27th of every month unless it's a weekend or holiday, then you're paid the previous workday.

Your options are as follows:

  • Schedule a year or two of a monthly recurrences for the 27th then go through the next 12/24 entries and manually fix the ones that fall on a weekend or holiday. This is probably the quickest and most effective method because you can quickly scan your calendar for conflicts.

    Using the calendar below, you can find only 3 instances where the 27th falls on a weekend in less than 30 seconds. Easter being a 4th entry is also simple to modify. It's simply not efficient to code this.

  • Create a CSV (Excel) file of your pay periods and convert them to .ics.

You're finding hard coded calendars with no logic because it's far easier to make the single change manually than to write the logic for it. Your payroll admin also processes these anomalous events manually. The problem with trying to automate this is...

  1. holiday events vary too much from culture to culture
  2. holiday events in calendars aren't "calculated" they're event entries like all else
  3. holiday events are not all equal. Not all banks/companies will observe all holidays (close).

enter image description here

No. You can't create a recurrence for this granular of a rule set.

  • I'm paid every month;
  • I'm paid always on the last possible day before the 28th day of the month;
  • I'm paid always on a working day.

So, to simplify it, you're paid the 27th of every month unless it's a weekend or holiday, then you're paid the previous workday.

Your options are as follows:

  • Schedule a year or two of a monthly recurrences for the 27th then go through the next 12/24 entries and manually fix the ones that fall on a weekend or holiday. This is probably the quickest and most effective method because you can quickly scan your calendar for conflicts.

    Using the calendar below, you can find only 3 instances where the 27th falls on a weekend in less than 30 seconds. Easter being a 4th entry is also simple to modify. It's simply not efficient to code these one-offs.

  • Create a CSV (Excel) file of your pay periods and convert them to .ics.

You're finding hard coded calendars with no logic because it's far easier to make the single change manually than to write the logic for it. Your payroll admin also processes these anomalous events manually. The problem with trying to automate this is...

  1. holiday events vary too much from culture to culture
  2. holiday events in calendars aren't "calculated;" they're event entries like every other event entry (team meeting, dentist appointment, parent/teacher conference, etc.)
  3. holiday events are not all equal. Not all banks/companies will observe all holidays (close).

You could create the code using an opensource ics library to generate the .ics files your particular organization, but you're not going to find this recurrence pattern available in the calendar apps.

 

2021 Yearly Calendar View

added 361 characters in body
Source Link
Allan
  • 104.4k
  • 33
  • 206
  • 470

No. You can't create a recurrence for this granular of a rule set.

  • I'm paid every month;
  • I'm paid always on the last possible day before the 28th day of the month;
  • I'm paid always on a working day.

So, to simplify it, you're paid the 27th of every month unless it's a weekend or holiday, then you're paid the previous workday.

Your options are as follows:

  • Schedule a year or two of a monthly recurrences for the 27th then go through the next 12/24 entries and manually fix the ones that fall on a weekend or holiday. This is probably the quickest and most effective method because you can quickly scan your calendar for conflicts.

    Using the calendar below, you can find only 3 instances where the 27th falls on a weekend in less than 30 seconds. Easter being a 4th entry is also simple to modify. It's simply not efficient to code this.

  • Create a CSV (Excel) file of your pay periods and convert them to .ics.

You're finding hard coded calendars with no logic because it's far easier to make the single change manually than to write the logic for it. Your payroll admin also processes these anomalous events manually. The problem with trying to automate this is...

  1. holiday events vary too much from culture to culture
  2. holiday events in calendars aren't "calculated" they're event entries like all else
  3. holiday events are not all equal. Not all banks/companies will observe all holidays (close).

enter image description here

No. You can't create a recurrence for this granular of a rule set.

  • I'm paid every month;
  • I'm paid always on the last possible day before the 28th day of the month;
  • I'm paid always on a working day.

So, to simplify it, you're paid the 27th of every month unless it's a weekend or holiday, then you're paid the previous workday.

Your options are as follows:

  • Schedule a year or two of a monthly recurrences for the 27th then go through the next 12/24 entries and manually fix the ones that fall on a weekend or holiday. This is probably the quickest and most effective method because you can quickly scan your calendar for conflicts.

  • Create a CSV (Excel) file of your pay periods and convert them to .ics.

You're finding hard coded calendars with no logic because it's far easier to make the single change manually than to write the logic for it. Your payroll admin also processes these anomalous events manually.

No. You can't create a recurrence for this granular of a rule set.

  • I'm paid every month;
  • I'm paid always on the last possible day before the 28th day of the month;
  • I'm paid always on a working day.

So, to simplify it, you're paid the 27th of every month unless it's a weekend or holiday, then you're paid the previous workday.

Your options are as follows:

  • Schedule a year or two of a monthly recurrences for the 27th then go through the next 12/24 entries and manually fix the ones that fall on a weekend or holiday. This is probably the quickest and most effective method because you can quickly scan your calendar for conflicts.

    Using the calendar below, you can find only 3 instances where the 27th falls on a weekend in less than 30 seconds. Easter being a 4th entry is also simple to modify. It's simply not efficient to code this.

  • Create a CSV (Excel) file of your pay periods and convert them to .ics.

You're finding hard coded calendars with no logic because it's far easier to make the single change manually than to write the logic for it. Your payroll admin also processes these anomalous events manually. The problem with trying to automate this is...

  1. holiday events vary too much from culture to culture
  2. holiday events in calendars aren't "calculated" they're event entries like all else
  3. holiday events are not all equal. Not all banks/companies will observe all holidays (close).

enter image description here

Post Undeleted by Allan
added 361 characters in body
Source Link
Allan
  • 104.4k
  • 33
  • 206
  • 470

I think you're makingNo. You can't create a recurrence for this overly complexgranular of a rule set.

  • I'm paid every month;
  • I'm paid always on the last possible day before the 28th day of the month;
  • I'm paid always on a working day.

These rules...So, to simplify it, you're paid the 27th of every month unless it's a weekend or holiday, then you're paid the previous workday.

I'm paid every month;
I'm paid always on the last possible day before the 28th day of the month;
I'm paid always on a working day.

Your options are as follows:

  • Schedule a year or two of a monthly recurrences for the 27th then go through the next 12/24 entries and manually fix the ones that fall on a weekend or holiday. This is probably the quickest and most effective method because you can quickly scan your calendar for conflicts.

  • Create a CSV (Excel) file of your pay periods and convert them to .ics.

Come outYou're finding hard coded calendars with no logic because it's far easier to be "I'm paid monthly onmake the last week daysingle change manually than to write the logic for it."

That's an option on both Calendar and Microsoft Office Your payroll admin also processes these anomalous events manually.

enter image description here

I think you're making this overly complex.

These rules...

I'm paid every month;
I'm paid always on the last possible day before the 28th day of the month;
I'm paid always on a working day.

Come out to be "I'm paid monthly on the last week day."

That's an option on both Calendar and Microsoft Office.

enter image description here

No. You can't create a recurrence for this granular of a rule set.

  • I'm paid every month;
  • I'm paid always on the last possible day before the 28th day of the month;
  • I'm paid always on a working day.

So, to simplify it, you're paid the 27th of every month unless it's a weekend or holiday, then you're paid the previous workday.

Your options are as follows:

  • Schedule a year or two of a monthly recurrences for the 27th then go through the next 12/24 entries and manually fix the ones that fall on a weekend or holiday. This is probably the quickest and most effective method because you can quickly scan your calendar for conflicts.

  • Create a CSV (Excel) file of your pay periods and convert them to .ics.

You're finding hard coded calendars with no logic because it's far easier to make the single change manually than to write the logic for it. Your payroll admin also processes these anomalous events manually.

Post Deleted by Allan
Source Link
Allan
  • 104.4k
  • 33
  • 206
  • 470
Loading