locked
Weird Datasource behavior in Sharepoint Designer??? RRS feed

  • Question

  • I have a list of employees with DOB, and a calculated column that calculcates their birthday THIS year. The calculate is as follows:

    =DATE(YEAR(Today),MONTH(DOB),DAY(DOB))

    When I look at the list is shows up fine. It's the same day, but just this year.

    So I got into Sharepoint Designer and grab the datasource and put it on the page, and all the sudden the "Birthday" column is now a day BEHIND DOB. I show the time and rather than being 12AM of today, the day is yesterday at 8PM, so each Birthday is one day off and the whole list is redenered useless.

    Why is it showing yesterday????

    Thursday, April 24, 2008 12:53 PM