Forum Discussion
Helper ICreating a table of recurring event instances between two dates
I have managed to use this as a guide to solve my problem. Commenting here in case it helps other in future.
Hi DebbieK ,
Could you please tell me how [StartDate], [EndDate] are calculated? I can't figure out the rules of their calculation.thanks.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Helper IHi Gao,
The start date and end date in table 1 are defined when the recurring events are created. So for example ID 1 is an "all day event" recurring every Friday from the 14th Oct 2022 until 29th Nov 2041.
The result I'm wanting is a table that outputs each instance as a separate line entry.
So again if we take ID 1 we would have a line with start date 14/10/22 at midnight until 14/10/22 at 11.59PM, and then the next line for ID 1 would be start date 21/10/22 at midnight until 21/10/22 at 11.59PM. Hope that makes sense?