none
Event Date

    Question

  • I am having difficulty restricting the rows from a SP list using the @EventDate aka StartTime.

    I want to just select one row, regardless of the time, for today's date. I have one different event for each day, and it is a recurring event every 21 days, perhaps that is what makes the difference.

    I have tried using the following, but all I get are either errors are no rows found:

    [ddwrt:FormatDate(string(@EventDate), 1033, 'yyyyMMdd') <=ddwrt:FormatDate(string(ddwrt:Today), 1033, 'yyyyMMdd')]

     

    Friday, December 16, 2011 10:40 PM

All replies