The fromICalendar property converts the ICalendar value to a VARIANT expression. The toICalendar property is the reverse function, so it converts a VARIANT expression back to iCalendar format. The valuesFromICalendar property returns values for known parameters of the giving expression ( available for exPropertyTypeDuration, exPropertyTypePeriod and exPropertyTypeRecur types )

Based on the Type parameter of the fromICalendar property, the type of the VARIANT being returned is:

• exPropertyTypeBinary, returns a safe array of bytes ( VT_ARRAY | VT_UI1 )
• exPropertyTypeBoolean, returns a boolean value ( VT_BOOL )
• exPropertyTypeCalAddress, returns a string value (VT_BSTR )
• exPropertyTypeDate, returns a DATE value ( VT_DATE )
• exPropertyTypeDateTime, returns a DATE value ( VT_DATE )
• exPropertyTypeDuration, returns a float value ( VT_R4 ) that indicates the duration in days for integer part, while the fractional part specifies hours, minutes and seconds. The valuesFromICalendar property returns values for known parameters of the giving expression. The exPropertyTypeDuration expression supports the following parameters:
  • "-", specifies whether the duration is negative or positive
  • "W", indicates the number of weeks
  • "D", indicates the number of days
  • "H", indicates the number of hours
  • "M", indicates the number of minutes
  • "S", indicates the number of seconds
  • "Duration", indicates the duration in days for integer part, while the fractional part specifies hours, minutes and seconds.

  For instance, the valuesFromICalendar("P12DT4H",exPropertyTypeDuration,"D") returns the number of days in the duration expression ( in this case 12 ), while the valuesFromICalendar("P12DT4H",exPropertyTypeDuration,"H") returns the number of hours in the duration expression ( in this case 4 ) .

• exPropertyTypeFloat, returns a double value ( VT_R8 )
• exPropertyTypeInteger, returns an integer value ( VT_I4 )
• exPropertyTypePeriod, returns a string value ( VT_BSTR ). The valuesFromICalendar property returns values for known parameters of the giving expression. The exPropertyTypePeriod expression supports the following parameters:
  • "Start", indicates the date to start the period
  • "End", indicates the date to end the period
  • "-", specifies whether the duration of the period is negative or positive
  • "W", indicates the number of weeks within period
  • "D", indicates the number of days within period
  • "H", indicates the number of hours within period
  • "M", indicates the number of minutes within period
  • "S", indicates the number of seconds within period
  • "Duration", indicates the duration of the period in days for integer part, while the fractional part specifies hours, minutes and seconds.

  For instance, the valuesFromICalendar("20010101T000000/P1D",exPropertyTypePeriod,"Start") returns the date to start the period ( in this case #1/1/2001# ), while the valuesFromICalendar("20010101T000000/P1D",exPropertyTypePeriod,"D") returns the number of days for the period expression ( in this case 1 ).

• exPropertyTypeRecur, returns a string value ( VT_BSTR ). The valuesFromICalendar property returns values for known parameters of the giving expression. The exPropertyTypeRecur expression supports the following parameters:
  • "FREQ", identifies the type of recurrence rule, and could by any of the following: "SECONDLY", "MINUTELY", "HOURLY", "DAILY", "WEEKLY", "MONTHLY", "YEARLY" 
  • "UNTIL", defines a DATE value that bounds the recurrence rule in an inclusive manner.
  • "COUNT", defines the number of occurrences at which to range-bound the recurrence.
  • "INTERVAL", contains a positive integer representing at which intervals the recurrence rule repeats.
  • "BYSECOND", specifies a COMMA-separated list of seconds within a minute.
  • "BYMINUTE", specifies a COMMA-separated list of minutes within an hour
  • "BYHOUR", specifies a COMMA-separated list of hours of the day
  • "BYDAY", specifies a COMMA-separated list of days of the week; SU indicates Sunday; MO indicates Monday; TU indicates Tuesday; WE indicates Wednesday; TH indicates Thursday; FR indicates Friday; and SA indicates Saturday. Each BYDAY value can also be preceded by a positive (+n) or negative (-n) integer. If present, this indicates the nth occurrence of a specific day within the MONTHLY or YEARLY "RRULE".
  • "BYMONTHDAY", specifies a COMMA-separated list of days of the month. Valid values are 1 to 31 or -31 to -1.
  • "BYYEARDAY", specifies a COMMA-separated list of days of the year. Valid values are 1 to 366 or -366 to -1.
  • "BYWEEKNO", specifies a COMMA-separated list of ordinals specifying weeks of the year. Valid values are 1 to 53 or -53 to -1.
  • "BYMONTH", specifies a COMMA-separated list of months of the year. Valid values are 1 to 12.
  • "BYSETPOS", specifies a COMMA-separated list of values that corresponds to the nth occurrence within the set of recurrence instances specified by the rule.
  • "WKST", specifies the day on which the workweek starts. Valid values are MO, TU, WE, TH, FR, SA, and SU. The default value is MO.

  For instance, the valuesFromICalendar("FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=SA,SU",exPropertyTypeRecur,"") returns all known properties of the recurrence rule like "BYDAY=SA,SU;COUNT=4;FREQ=WEEKLY;INTERVAL=2", while the valuesFromICalendar("FREQ=WEEKLY;INTERVAL=2;COUNT=4;BYDAY=SA,SU",exPropertyTypeRecur,"FREQ") returns the value of the FREQ parameter ( in this case WEEKLY ).

• exPropertyTypeText, returns a string value ( VT_BSTR )
• exPropertyTypeTime,  returns a DATE value ( VT_DATE )
• exPropertyTypeURI, returns a string value ( VT_BSTR )
• exPropertyTypeUTCOffset, returns a string value ( VT_BSTR )