ARI Soft - date filtering by range

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

more...
31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

date filtering by range

(1 viewing) (1) Guest

Page: 1

TOPIC: date filtering by range

Forum Tools

#57674

date filtering by range 8 Years, 6 Months ago Karma: 0

I want to add filtering table by date range. I created a simple form with two jQuery datepickers. I used the example of SQL query from this thread ,but I got a syntax error. Any ideas how to solve this problem?

Code:



SELECT

 id,

 Machine,

DateSostavleniya

FROM

jos_addRabotyAndProstoyMain

WHERE

 ({$REQUEST:start_date|empty:} <> '' AND DateSostavleniya >= {$REQUEST:start_date|empty:})

 AND

 ({$REQUEST:end_date|empty:} <> '' AND DateSostavleniya <= {$REQUEST:end_date|empty:})

Form: