Rank: Member
Groups: Registered
Joined: 4/7/2019(UTC) Posts: 24   Thanks: 7 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.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 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...
|
|
|
|
|
|
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.
