1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice
  2. If you update to Joomla 3.9.16, you will have to update Fabrik from the latest GitHub version, to fix a bug introduced in Joomla, which makes it impossible to list front end folder locations in backend JForms. This affects things like template selection.
    Dismiss Notice

MENU filter Current_Date

Discussion in 'Community' started by javier94, Feb 13, 2020.

  1. javier94

    javier94 Member

    Level: Community
    hello i have a list like this


    i would like to add a new filter where show only the registers with data and hour bigger than now in the fi inscripcions colum.. as you can see only 2 elements are bigger than now..

    i try with this filter menu

    and "element" fi inscripcions -- "condition" greater than -- "value" Current_date ... "type" EVAL.. but is not working.. maybe i have to add anything else in current date??? like a $ or similar? or capitals?

    thanks in advance!
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
  3. javier94

    javier94 Member

    Level: Community
    Following your instructions.. i have check all the information.. so..

    I want to compare 2 dates --> 1 date is fi inscripcions... saved --> and 2 date will be the UTC data & local time

    if local time is equal or bigger than fi inscripcions --> will not show the register
    if local time is lower than data of fi inscripcions --> Will show the register

    so the filter should be like this.

    field = Fi_inscripcions
    condition: equal or greater than
    value: NOW()
    type=no quotes

    so if we have the column fi inscripcions..(last one)


    only 2 register should appear.. for the year 2020 --> and i can not see any register... so something is not calculating in the right way

    Any suggestion?
  4. javier94

    javier94 Member

    Level: Community
    i used CURRENT_DATE() and is working..



Share This Page