cm
New Member
Posts: 4
|
Post by cm on Jan 31, 2022 16:31:01 GMT
How can i implement to trigger a bet only on some weekdays ex. using DATEPART(dw,GETDATE()) or only in a specified timeframe within a day?
|
|
|
|
Post by Ipposnif on Jan 31, 2022 16:56:06 GMT
Hi, for the timeframe you can use the strategy's criteria "Event Start Time" e "Tmz". For example you can insert 14:30:00 16:30:00 tmz=0 (UK).
For the weekdays, you are right you have to use datepart in the criteria "Trigger Condition" of the bet.
DATEPART(dw,GETDATE()) IN (1,2,3,5)
|
|
cm
New Member
Posts: 4
|
Post by cm on Jan 31, 2022 17:02:04 GMT
Ok and if I want to use race datetime not current time GETDATE()?
|
|
|
|
Post by Ipposnif on Feb 1, 2022 7:31:52 GMT
|
|
cm
New Member
Posts: 4
|
Post by cm on Feb 1, 2022 13:41:10 GMT
Is not that i am looking for. I just want to know if I can get in a variable the start datetime of a race.
Example, if is monday and betting on 100 races it will overlap over next two days tuesday and wednesday, so cannot use GETDATE in this case...
|
|
|
|
Post by Ipposnif on Feb 1, 2022 16:27:29 GMT
No there isn't yet a variable for this, I will add it in the next version.
But you can replace the variable with this select:
(select data from tbl_races where id=@id_race)
p.s.
keep it between parentheses when doing the comparison
|
|
