New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

The forum below will remain in read only mode.

Yay... Take Me to the Community!

Form and list filters

You are not authorized to post a reply.
Sort:
Vicenç Masanas
New Member
New Member
Posts:47
Association Member

    Is there a way to filter results of a Form and List module based on current date?

    The forms module has the following fields:

    • Date_Start (Date)
    • Date_End (Date)
    • Enabled (Date)

    And I'd like to filter the results on something like this (it it was sql):

    where Date_start <= getdate() and Date_end >= getdate() and Enabled = 1

    Sebastian Leupold
    New Member
    New Member
    Posts:54

      (deleted)

      Vicenç Masanas
      New Member
      New Member
      Posts:47
      Association Member
        Thank you Sebastian, you put me in the right direction.
        This is how my filter looks like now:

        [DateStart_UDT_Ticks] <= [Ticks:Today] and [DateEnd_UDT_Ticks] >= [Ticks:Today] and [Enabled_UDT_Original] = true
        You are not authorized to post a reply.

        Hosting liberally provided by