I still have this problem:

I show upcoming calendar events during the next week or two at the top of my main action grid. This allows me to order them in a mix with todos from the grid.

So say I have an appointment at three, I can put two gardening todos on top, then have the appointment as the next item in the grid and below I can have a 'prepare dinner' todo or some such. This create a timeline of upcoming stuff in the same place has become essential to my workflow.

My problem is with representing the day of the week of recurring appointments in the grid. All I've managed to achieve is to display (in a column) the day of the week of the first occurrence in the grid (I use Day([A_ApptString]), with ApptString being ="[A_Appointments]"). The issue here is that starting from the second recurrence e. g. of a yearly event, the day of the week will be off as the formula can only get at the date of the first creation of the recurring event. Having the wrong day of the week show up in the column has led to a lot of confusion. Sometimes I add the day of the week for the current occurrence manually at the start of the item text but that's not really a great solution either.

If anyone has any idea for a formula to get at the weekday of the next recurrence programmatically within IQ, please let me know. If there is no other native solution, by now I'd be prepared just to use a kind of mechanism to change the date of the recurring event to the date of its next occurence, i. e. to 'overwrite' any kind of history for that date. Could this be done, perhaps running it periodically once a week or so? Find all recurring events and set their original date to that of the next recurrence...

Or perhaps an item's next recurrence could be added as a field in IQ?

If none of that is going to materialize, I guess I'll have to write an Autohotkey script that copies the date and type of recurrence from the properties pane or some such and creates the reference in the grid with the correctly calculated weekday.

Many thanks!