This is a migrated thread and some comments may be shown as answers.

How to find Scheduler Endtime

0 Answers 88 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Pragya
Top achievements
Rank 1
Pragya asked on 16 Jun 2017, 08:48 AM

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

No answers yet. Maybe you can help?

Tags
Scheduler
Asked by
Pragya
Top achievements
Rank 1
Share this question
or