Categories: Setup & privacy :

Why an event set to repeat on say 31st(or last day) of each month does not work

Showing 1-19 of 19 messages
Why an event set to repeat on say 31st(or last day) of each month does not work robinkansara 3/27/09 12:49 AM
This is actually a suggestion for a feature.
In google calendar whenever you add an event on say 31st March and set it to repeat each month, it would only repeat for months that have 31 days. There is no occurrence of the event for months that have 30 days or for February.
However, if you do the same in MS outlook, it just says that some months have fewer than 31 days and for those months, the event will be added on the last day of the month. So elegant.

I wonder how google missed out on such a tiny yet important detail. i use google calendar extensively and would like this feature to be incorporated in it rather than using workarounds suggested on the forum to fix it.
Re: Why an event set to repeat on say 31st(or last day) of each month does not work tpuiatti 3/27/09 1:47 AM
You can write your event in iCal syntax and import. I've done a last day of month one for you below named Robin Event starting 31-Jan. You can rename it as you wish then save as ics file type in a text editor like notepad and import - you should be able to edit it and add notifications after import.

BEGIN:VCALENDAR
BEGIN:VEVENT
DTSTART:20090131
DTEND:20090131
RRULE:FREQ=MONTHLY;BYDAY=SU,MO,TU,WE,TH,FR,SA;BYSETPOS=-1;WKST=SU
SUMMARY:Robin Event
END:VEVENT
END:VCALENDAR
Re: Why an event set to repeat on say 31st(or last day) of each month does not work robinkansara 3/31/09 9:00 PM
Hi Thanks tpuiatti,

   I just wanted this to be added in Google calendar itself. Anyways thanks for the help.

regards,
Robin
Re: Why an event set to repeat on say 31st(or last day) of each month does not work agnivohneb 4/30/09 9:21 PM
not working tpuiatti
Re: Why an event set to repeat on say 31st(or last day) of each month does not work igor N. 5/16/09 6:35 AM
Alternatively, set the recurring event is the 1 st of each month.
A reminder, specify the parameters for 1 day before the event.
Re: Why an event set to repeat on say 31st(or last day) of each month does not work tpuiatti 5/17/09 11:49 AM
agnivohneb - what error did you get? (tested and worked my end)
Re: Why an event set to repeat on say 31st(or last day) of each month does not work Castlemaine 7/30/09 4:48 PM
tpuiatti - thanks for the suggestion.  It worked for me.  I then modified the ics entry to have an event occur on the last weekday of the month at a specific time.  In my case I needed it to occur on the last working day at 18:00 Brisbane time (GMT +10).
 
BEGIN:VCALENDAR
BEGIN:VEVENT
DTSTART:20090131T080000Z
DTEND:20090131T080000Z
RRULE:FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-1;WKST=SU
SUMMARY:Update stock prices
END:VEVENT
END:VCALENDAR
Re: Why an event set to repeat on say 31st(or last day) of each month does not work jcm a 8/4/09 8:18 AM
The ical code seems to work (for people with ical and who have synced ical to google calendar).

Though I do get the message on google calendar that: "This event has a recurrence rule that cannot be edited in Google Calendar".

Ideally Google should be able to handle this cleanly.

Come on google, this should work automatically.  You've already got the code to do something on the last ***day of the month, why not the last day of the month, or 2 back from the end?  This should be a quick change to do.
Re: Why an event set to repeat on say 31st(or last day) of each month does not work Carbine 12/24/09 10:17 AM
Puiatti,

Tried it, but it didn't work.  At first, I saw that it saved in .rtf, so I opened Excel, pasted, and saved in .csv format (I couldn't find ics format). I used the "Add" link in Google calendar, browsed for the file, and the import worked.  But the event only showed up as one single event, not a repeating event.  I tried changing the enddate in the .csv file, did a redo, but it came out as one long continuous event lasting 10 years.

Online banks and such do it all the time; they take a payment on the first or last day of the month, or the first or last weekday of the month, so the code is out there.  Thanks for trying, anyway.
Re: Why an event set to repeat on say 31st(or last day) of each month does not work tpuiatti 12/25/09 10:49 AM
Carbine, the csv import won't do the job as it's not recognized as iCalendar spec, just paste the text into a basic text editor like Notepad and save it with the extension .ics (type your filename with the ".ics" extemsion e.g. event.ics in the filename field - it won't be an available format from the file type drop down) and import it. I have just tested this and the event imports ok but the recurrence cannot be edited in G/Cal's interface. Choose the first event written on this thread for last day of the month or the 2nd one posted by Castlemaine for last weekday of the month.
Re: Why an event set to repeat on say 31st(or last day) of each month does not work vsh 5/11/10 2:20 PM
After reading this thread I thought I had a solution to my problem, but no such luck.  :-(

I want to create an event that repeats annually on the Sat, Sun, and Mon of Memorial Day weekend (where Memorial Day is the last Monday in May).  After studying rfc-5545 (http://tools.ietf.org/html/rfc5545), I thought this would work:

BEGIN:VCALENDAR
BEGIN:VEVENT
DTSTART:20100529
DTEND:20100531
RRULE:FREQ=YEARLY;BYDAY=SA,SU,MO;BYWEEKNO=21;WKST=TU
SUMMARY:MV Bike Trip
END:VEVENT
END:VCALENDAR

I was able to import this into Google calendar, but it only chose Sat and Sun -- I infer it ignored the WKST directive.  Furthermore, when  I attempted to edit the entry, it hung the tab in Firefox ("Loading...").

Maybe someday...
Re: Why an event set to repeat on say 31st(or last day) of each month does not work tpuiatti 8/5/10 6:14 PM
@vsh

G/Cal still has limitations in handling the RFC5545 full spec and I have had issues using the BYWEEKNO rule previously. I prefer to specify the nth weekday of a month using BYMONTHDAY.

We know Memorial Day must lie between May 25 to May 31 and thus that the Saturday that precedes it must lie between May-23 and May-29. So...

BEGIN:VCALENDAR
BEGIN:VEVENT
DTSTART:20100529
DTEND:20100601
RRULE:FREQ=YEARLY;BYMONTH=5;BYMONTHDAY=23,24,25,26,27,28,29;BYDAY=SA

SUMMARY:MV Bike Trip
END:VEVENT
END:VCALENDAR

This tests ok. Download from link.

BYYEARDAY specified in countdown form to allow for Feb-29 will also do the job elegantly in 2 rules:-

BEGIN:VCALENDAR
BEGIN:VEVENT
DTSTART:20100529
DTEND:20100601
RRULE:FREQ=YEARLY;BYYEARDAY=-223,-222,-221,-220,-219,-218,-217;BYDAY=SA

SUMMARY:MV Bike Trip
END:VEVENT
END:VCALENDAR
Re: Why an event set to repeat on say 31st(or last day) of each month does not work cmbilotta 12/8/10 7:20 PM
I agree with Robin that Google should consider adding this particular feature to Calendar.  I dislike having to go in and manually edit all of my end of the month paydays and events because it bumps to the 1st on months of which there are only 30 days...don't even get me started on February haha.  It does seem like it is such an essential feature to a calendar. Calendar has every two weeks, certain weekdays repeated, but not this.
Re: Why an event set to repeat on say 31st(or last day) of each month does not work Patrick_Rice 1/13/11 4:59 AM
Anyone know how I can really take this to a harder level, and set a repeated entry for the:

 "LAST WORKING DAY (WEEKDAY) OF THE MONTH" ?

As this is how I am monthly paid by my employer - not on the last day of the month (that would be too easy), but on the last WORKDAY/WEEKDAY of any month.

Anyone know how I set that up, or how I create an iCal / vCal for THAT one then...?
Re: Why an event set to repeat on say 31st(or last day) of each month does not work Patrick_Rice 1/13/11 5:44 AM
I resolved it myself...

I had to create an iCal file and do it that way.  Feel free to use as needed:

BEGIN:VCALENDAR
METHOD:PUBLISH
BEGIN:VEVENT
DTSTART;TZID=GMT:20100131
DTEND;TZID=GMT:20100131
RRULE:FREQ=MONTHLY;BYDAY=MO,TU,WE,TH,FR;BYSETPOS=-1;WKST=MO
SEQUENCE:0
SUMMARY:DCC - Pay Day
CLASS:PUBLIC
STATUS:CONFIRMED
END:VEVENT
END:VCALENDAR


1. Open up notepad and copy and paste the code above (the stuff in CAPS).
2. Save it with a relevant name, BUT change the extension to .ics
3. In your Google Calendar or Google Apps Calendar, click the SETTINGS option at the near top right, and choose Calendar Settings, if necessary (for GApps users).
4. Click on the Calendars Tab, adn then choose Import Calendar
5. Browse to the .ics file you created and saved earlier, and select that, and then tell Google WHICH Calendar you want to import it into (IF you have multiple Calendars).
6. Voila - it should be in, as a repeat entry, that occurs on the last WORKING/WEEKDAY of the month.
----

NOTES:

1. Change the "SUMMARY" line to say whatever you want the entry to be called.
2. This formula will create an entry for the whole of 2010 onwards.  If you only want it to start from a certain point in the year, change BOTH the entries "20100131" above to the month you want it to start from, ENSURING you use the correct last day of month, so for example, to start this from the end of November, you would need to use 20101130, as November only has 30 days - using 31 will mess everything up as there is no 31st November.
3. Note also I have changed the "WKST" entry to MO for my Calendar, as my work week is set to start on a Monday.  Leave/Set this to SU if your weeks start on a Sunday.
4. Note also that to have got this to work for last WORKING day of the month, I have amended the "BYDAY" entries to omit SA, SU, - if you want a repeat entry for the last day of the month, regardless of working day or weekend day, then include SA, SU, on this line.
5. Finally, please note, that there is currently NO WAY for Google to know if a certain day is a Public Holiday, such as a Bank Holiday, and amend the date accordingly - in other words, if the last 'Weekday' in August - the 31st of August, was a Monday for example, BUT that date was also of course to be a Bank Holiday, then it would still create your entry as being on the 31st of August.  That is to say, this formula will ensure it creates your entry on a WEEK DAY, and not a weekend day, but it cannot know if the WEEK DAY just happens to be a Bank Holiday though - there is no way around this, in an automated sense.
Re: Why an event set to repeat on say 31st(or last day) of each month does not work SiloDog 1/24/11 6:53 AM
Excellent Patrick_Rice !!! Every University Employee thanks you!!!
Re: Why an event set to repeat on say 31st(or last day) of each month does not work rlinhartpdx 7/25/12 2:18 PM
Still need to check for events that land on a Holiday. Still better than most solutions so far.
Re: Why an event set to repeat on say 31st(or last day) of each month does not work rlinhartpdx 7/25/12 2:34 PM
Also just noticed some strangeness with events from this that land on a holiday. For example, December 2012 falls on Monday the 31st which is a holiday. I tried to change it to Friday the 28th but the "to" date defaults to Thursday the 27th and "Sorry, you can't create an event that ends before it starts." Changing to "to" date appears to work normally.


Re: Why an event set to repeat on say 31st(or last day) of each month does not work Nuwan Senaratne 11/26/12 5:46 PM
Thanks, it works properly :)