SharePoint 2010 Filter View by Quarter (Date)

This is an example of how you could create a view, with the help of calculated columns, to filter items in a SharePoint list by the quarter.

First, create 2 calculated columns of type Date and Time that will be the quarter start and quarter end of your preferred date.
e.g.
the date today: 5/7/2014 (Q2)
quarter start will be (1/4/2014) while quarter end will be 30/6/2014

Bopiliao Old Street 剝皮寮歷史街區, Taiwan

This is part of the fun Taiwan travel series. View the full itinerary here.

Bopiliao Old Street is a place rich in heritage and culture. It was made famous after the movie Monga was filmed here. It has been in existence since the Qing period, and has stood the test of time throughout the Japanese occupation and the development of Mengjia.

Nowadays it is well known as the one of the cultural highlights of traditional Taiwan, and here you could find Chinese herb shops, antique shops, prayer paraphernalia and established eateries.
It is also close to the famous Longshan temple.

Ximending - Ya Rou Bian 鴨肉扁, Taiwan

This is part of the fun Taiwan travel series. View the full itinerary here.

It was late evening by the time we ended our one-day excursion, so Andy our tour guide very kindly dropped us off at Ximending where we could grab a bite.

Ximending needs no introduction - it's an extremely popular spot where the young and trendy hang out. And for good reason too - here you find established eateries, popular fashion, hip cafes, specialty shops,  traditional snacks all nestled side by side.
There's always something for everyone.

SharePoint InfoPath 2010: C# populate rows in a repeating table

I had an InfoPath form where I needed to have 2 views. In the 2nd view, some information in the repeating table would be automatically populated based on the information entered in the first view.

Initially I wanted to use a rule-only approach but it ended up being too cumbersome; I had to resort to code :(

I will use a time card with date range as an example here. The repeating table will have one row for each day within the date range I have selected.

AgilePoint: Clean up participant list

In a AgilePoint workflow template, you might have created some activities and assigned some participants to them, just to decide that you don't need them at a later stage.

To keep the template clean, always use the Custom Process Properties to manage and delete them.

You can find the Custom Process Properties under the Miscellaneous section of the AgilePoint tab in your Visio.

Highlight the line you do not need and click the Remove button.

And you're done.

Danshui Fisherman's Wharf 淡水漁人碼頭 and Lover's Bridge, Taiwan

This is part of the fun Taiwan travel series. View the full itinerary here.

Fisherman's Wharf is a leisure fishing port and a famous attraction in Danshui. It is said to have one of the best sunset views.

There are numerous hotels, restaurants and shops that could be found here.

Danshui old street 淡水老街, Taiwan

This is part of the fun Taiwan travel series. View the full itinerary here.

After a late lunch at Fuji harbor, we continued our journey to Danshui.

There are a few things you can do in Danshui:

1) Try the fish balls

2) Buy Iron eggs and Fish crackers

3) View the sunset at Fisherman's Wharf

4) Try the famous Ah-Ge snack (glass noodles wrapped in tofu skin)

5) Take the ferry ride to Fisherman's Wharf to soak in the beautiful views.

Danshui river is really huge. If I didn't know better I would have thought it is a seaside harbor.

There are a lot of things to see and eat in Danshui!