- lets say we have a column with the name DOB which stores the date of birth in datetime format.
- Create a computable column give it a name as DOBthisYear and add this "=TEXT(DOB,"M/D/")&TEXT(Today,"YYYY")" without first and last quotes :-)
- now lets view the list again where it shows the DOB for current year.
- Open the page in Designer and edit the page. Browse through the Datasource in the site and drag and drop the list to your place.
- Now it will add the powerful DataformWebpart. in a list view. Now add a filter to the list in the column DOBthisYear which equals [Current Date].
- Save the dataformwebpart give some formatting with the image of the employee to show up in the list.