Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 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.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


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




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

date filtering by range
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: date filtering by range
#57674
date filtering by range 7 Years, 11 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:

Last Edit: 2016/05/16 06:26 By vital2207.
The administrator has disabled public write access.
 
#57675
Re:date filtering by range 7 Years, 11 Months ago Karma: 747
Hello,

Send your order number by email please.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1