How to find Scheduler Endtime

1 posts, 0 answers
  1. Pragya
    Pragya avatar
    1 posts
    Member since:
    Jun 2017

    Posted 16 Jun 2017 Link to this post

    Hi.

    I am new to kendo scheduler. Please help me with following issue:

    DTSTART:20170614T133000Z // This is event start time

    DTEND:20170614T140000Z // This is event end time

    Recurrence rule: FREQ=YEARLY;INTERVAL=2;UNTIL=20260616T182959Z;BYMONTH=6;BYMONTHDAY=14

    I am using following method in my SQL procedure to get all event occurence between 'rangestartdate' and 'rangeenddate'

    SELECT * FROM dbo.ExpandRecurrence('DTSTART:20170614T133000Z ' + Char(10) + 'DTEND:20170614T140000Z ' + Char(10) + 'RRULE:FREQ=YEARLY;INTERVAL=2;UNTIL=20260616T182959Z;BYMONTH=6;BYMONTHDAY=14',  'rangestartdate'  ,'rangeenddate' )

    I consider, the event start date to be the 'rangestartdate'.The problem is how to determine, the value for 'rangeenddate'??

    Please reply, as i am stuck with this problem and finding no solution elsewhere.

    Thanks

Back to Top