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

Notification

Icon
Error

Options
Go to last post Go to first unread
j.torres@tewis.com  
#1 Posted : Friday, April 26, 2019 11:48:08 AM(UTC)
j.torres@tewis.com

Rank: Member

Groups: Registered
Joined: 4/7/2019(UTC)
Posts: 21
Spain

Thanks: 6 times
Hello. One of my reestrictions is a Datetime column. The operator is "Is Between" so I've to specify Value 1 and Value 2. In one hand, I've the limitation that there is no way to specify the time, and if it's possible I don't know how. In the other hand, the value 1 date that I specify puts the current time in the sql statement. For instance, if Value 1 = 26/04/2019 and Value 2 = 27/02/2019, then the SQL statement for the reestriction is this: ....BETWEEN '2019-04-26 13:39:40' AND '2019-04-27 00:00:00'. Why is taking the current time. It seems like is takink the "Now" keyword.
epf  
#2 Posted : Friday, April 26, 2019 1:19:32 PM(UTC)
epf

Rank: Administration

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

Thanks: 12 times
Was thanked: 116 time(s) in 113 post(s)
If you set the 'Format' property of your element or restriction to 'General Date Short Time', you should be able to enter the time...
Users browsing this topic
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.