Value formatting elements include:

• sd - Returns the culture's standard shortened date format (m/d/yyyy in the US)
• d - Day of the month 1 - 31.
• dd - Two digit day of the month 01 - 31.
• ddd - Abbreviated day of the week (Mon, Tue, etc.)
• dddd - Full day of the week (Monday, Tuesday, etc.)
• M - The month, from 1 through 12
• MM - The month, from 01 through 12
• MMM - The abbreviated name of the month (Jan, Feb, etc.)
• MMMM - The full name of the month
• yy - The year, from 00 to 99
• yyyy - The year as a four-digit number

• st - Returns the culture's standard shortened time format (h:mm am/pm in the US)
• h - The hour, using a 12-hour clock from 1 to 12
• hh - The hour, using a 12-hour clock from 01 to 12
• H - The hour, using a 24-hour clock from 0 to 23
• HH - The hour, using a 24-hour clock from 00 to 23
• m - The minute, from 0 through 59
• mm - The minute, from 00 through 59
• s - The second, from 0 through 59
• ss - The second, from 00 through 59
• tt - The AM/PM designator

For even more options see the Microsoft .Net Custom Date and Time Formatting Reference Guide.

"Person": {
    "FirstVisit": "2/13/2011 8am"
}

Ted's first visit was on {{ Person | Attribute:'FirstVisit' | Date:'dddd, MMMM d, yyyy' }}.

Ted's first visit was on Sunday, February 13, 2011.

By default this filter assumes the amount you pass in is in days. You can also pass in other intervals as a second parameter like:

{{ 'Now' | DateAdd:-12,'h' }}

This would subtract 12 hours from the current date/time.

• y - Years v8.0
• M - Months v8.0
• w - Weeks v8.0
• d - Days
• h - Hours
• m - Minutes
• s - Seconds

Adding weeks is simply a shorthand for adding by 7 days at a time.

"CurrentPerson": {
    "FirstVisit": "2/14/2011"
}

Your first visit was {{ CurrentPerson | Attribute:'FirstVisit' }}. Two weeks later would be {{ CurrentPerson | Attribute:'FirstVisit' | DateAdd:14 }}.

Your first visit was 2/14/2011. Two weeks later would be 2/28/2011.

Valid units are:

• Y - Years
• M - Months
• w - Weeks v17.0
• d - Days
• h - Hours
• m - Minutes
• s - Seconds

"Person": {
    "FirstVisit": "2/14/2011",
    "SecondVisit": "3/18/2011"
}

It was {{ Person.FirstVisit | DateDiff:Person.SecondVisit,'d' }}
days between {{ Person.NickName }} first and second visit.

It was 32 days between Ted's first and second visit.

This filter has some optional input parameters:

• The number of occurrences to display (optional): The default is 1. A text value of 'All' can also be used to return all the occurrences (up to one year's worth).
• enddatetime: (optional) v7.0 if 'enddatetime' is provided, the EndTime property of the iCal's occurrence is returned instead of the StartTime.

"EventItemCampuses": {
    [
        { 
            "ContactEmail": "jenny@rocksolidchurchdemo.com",
            "EventItemSchedules": [
                { 
                    "Schedule": {
                        ... ,
                        "iCalendarContent": "BEGIN:VCALENDAR VERSION:2.0 PRODID:-//ddaysof...",
                        ... ,
                    }
                }
            ]
        }
    ]
}

{% assign upcomingDates =  EventItemSchedules | Select:'Schedule' | Select:'iCalendarContent' | DatesFromICal:2 %}

<ul>
{% for date in upcomingDates %}
    <li>{{ date }}</li>
{% endfor %}
</ul>

{% assign upcomingEndDates =  EventItemSchedules | Select:'Schedule' | Select:'iCalendarContent' | DatesFromICal:2,'enddatetime' %}

<ul>
{% for endDate in upcomingEndDates %}
    <li>{{ endDate }}</li>
{% endfor %}
</ul>

<ul>
    <li>7/15/2015 7:00:00 PM</li>
    <li>7/16/2015 7:00:00 PM</li>
</ul>

<ul>
    <li>7/15/2015 8:00:00 PM</li>
    <li>7/16/2015 8:00:00 PM</li>
</ul>

Valid return values are:

• X days ago
• yesterday
• today
• tomorrow
• in x days

"Person": {
    "FirstVisit": "2/14/2015",
}

Visited {{ Person.FirstVisit | DaysFromNow }}.

Visited 14 days ago.

There are several options on how to provide the month/year combination to check for. Valid methods include:

• {{ 'now' | DaysInMonth }} - Get the days in the current month/year.
• {{ '2/1/2017' | DaysInMonth }} - Get the days in the date provided.
• {{ '' | DaysInMonth:'02','2016' }} - Get the days based on the month/year provided.

None

There are {{ 'now' | DaysInMonth }} days in the current month.

There are 31 days in the current month.

This filter will accept input in the following formats:

• String (that can be parsed into a date)
• Date
• DateTime
• DateTimeOffset

The filter will attempt to parse each parameter (input, start of range, end of range) into a valid DateTime and check if the input falls within the range (inclusive). A boolean value will be returned.

"Items": [
    { 
        "Id": 1, 
        "Title": "Easter Devotional",
        "FeaturedDates": "4/10/2022 to 4/20/2022" 
    },
    { 
        "Id": 2, 
        "Title": "Christmas Devotional",
        "FeaturedDates": "12/20/2022 to 12/31/2022" 
    },
]

{% assign today = '2022-04-17 07:00' | Date:'yyyy-MM-dd HH:mm' %}
{% for i in Items %}
    {% assign startDate = i.FeaturedDates | Split:' to ' | First %}
    {% assign endDate = i.FeaturedDates | Split:' to ' | Last %}
    {% if i.FeaturedDates != '' %}
        {% assign isFeatured = today | IsDateBetween:startDate,endDate %}
        {% if isFeatured %}
            {{i.Title}}
        {% endif %}
    {% endif %}
{% endfor %}

Easter Devotional

Keep in mind that Rock considers Sunday to be the last day of the week. This makes sense when calculating church metrics. The 'Now' keyword can be used in place of a date for the current date.

"CurrentPerson": {
    "FirstVisit": "2/14/2011"
}

You first visited on the week of {{ CurrentPerson | Attribute:'FirstVisit' | SundayDate }}.

You first visited on the week of 2/20/2011.