-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Please help me to write a query to the database
- Thread starter kamil
- Start date
lcollong
FabriKant d'applications web
Hi,
fabrik-->list-->data-->prefiltrer then add a prefilter select your field , then the condition ( "EQUAL" or better "GREATER THAN" or "LESS THAN") and in the value field : NOW() . Set the type to QUERY. The field you select to compare against "now" has to be of type DATE
fabrik-->list-->data-->prefiltrer then add a prefilter select your field , then the condition ( "EQUAL" or better "GREATER THAN" or "LESS THAN") and in the value field : NOW() . Set the type to QUERY. The field you select to compare against "now" has to be of type DATE
lcollong
FabriKant d'applications web
Sorry: I did not see the "old year" 
I guess (but not sure) that Mysql won't be able to deal with dates prior to 1970 as well as unix/linux itself.
Maybe you could describe a little more what you're trying to achieve ?
I would probably use 3 separate elements (day, month and year) to store event's dates. Then a calc element could be use to display a combined date. Filters could applied to the year/month values.
I guess (but not sure) that Mysql won't be able to deal with dates prior to 1970 as well as unix/linux itself.
Maybe you could describe a little more what you're trying to achieve ?
I would probably use 3 separate elements (day, month and year) to store event's dates. Then a calc element could be use to display a combined date. Filters could applied to the year/month values.
