Everytime when starting a new project. When setting up the scaffolding for the application, a days work means a lot of clearly visible results.

Then again at the end of the project when everything seems to be on a highway to disaster but you are still able to pull it through.

And in the very end when a customer is happy with the end result and the application you made really makes a difference.