1. Fabrik 3.9 has been released. If you have updated Joomla to 3.9, this is a required update.
    Dismiss Notice

MENU filter Current_Date

Discussion in 'Community' started by javier94, Feb 13, 2020 at 12:50 PM.

  1. javier94

    javier94 Member

    Level: Community
    hello i have a list like this

    filter-1.png

    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.

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

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

    filter-1.png

    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..

    thanks

    Javier
     

Share This Page