Pre-filter on Date not working as per WIKI?

[CountryTrash]

Hi there,

I have joined my tender_register table and the jos_users table to my Tender_invitation table

I first added a prefilter to present only the tenders applicable to the logged in user.

jos_users.id EQUALS {$my->id} (text)

That works
I then consulted the prefilter wiki for the date related prefilters

I now want to add an "AND" condition where

tenders_register.closingdate GREATER OR EQUALS NOW() (No quotes)

Now I get "no records"

If I delete the {$my->id} prefilter bit it still reports no records so I am deducing that either there is an issue or I have the syntax wrong

 

[troester]

You can enable fabrikdebug (in fabrik options) and append &fabrikdebug=1 to your URL.
list GetData will show you the prefilter query.

Do you have records closingdate >= NOW()?
I think Now() is including the time so if your date is today 00:00 it will be < Now()

 

[CountryTrash]

Hi Troester,

Actually got it right. I trawled the fabrik 2.0 threads as well and found a date related prefilter question that suggested CURDATE(). I changed it to that and it now works ...

I think that the wiki could be updated to show that.

Can we assist with updates/learnings?

 

[troester]

You can create a WIKI account.
You should be able to modify existing pages.
For adding new ones I think Rob must add you.