logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
gaurav11  
#1 Posted : Thursday, September 07, 2017 11:55:12 AM(UTC)
gaurav11

Rank: Newbie

Groups: Registered
Joined: 3/17/2017(UTC)
Posts: 6
India
Location: India

Thanks: 2 times
Was thanked: 1 time(s) in 1 post(s)
Need to achieve something like this
"'"+model.GetRestrictionByName("Start Date").Date1+"' Between start_date and end_date"
When using restriction for a specific date is between the start date and end date field.
epf  
#2 Posted : Friday, September 08, 2017 6:10:35 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 387
Switzerland

Thanks: 6 times
Was thanked: 51 time(s) in 50 post(s)
You can use the restriction operator 'Value Only' which will just replace the value in your WHERE clause.
The value can be prompted and you can also change the operator label in the Advanced Properties of the restriction,

Here is a sample with Order Date:
[Order Date '08.09.2017'] between start_date and end_date

And this generates the SQL:
Code:

SELECT DISTINCT
  Orders.OrderDate AS C0
FROM Orders
WHERE 42986.3375578704 between start_date and end_date
ORDER BY Orders.OrderDate ASC
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 2.0.0 | YAF © 2003-2017, Yet Another Forum.NET
This page was generated in 0.095 seconds.