Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have to check if Intervallo is between 0 and 1 hour, how can i do it? thanks
anag_nome_sala | Gioco | anag_nome_giorno | giorno_partita | Lunedì_open | Orario_Fine_Part | win | Orario_Fine_Part | Intervallo |
- | ||||||||
AMERICA | BINGO | lun | 24/09/2018_201 | 09:00:00 | 04:44:00 | 15,66 | 04:44:00.0000000 | 04:16:00 |
AMERICA | BINGO | lun | 24/09/2018_200 | 09:00:00 | 04:38:00 | 10,44 | 04:38:00.0000000 | 04:22:00 |
AMERICA | BINGO | lun | 24/09/2018_199 | 09:00:00 | 04:31:00 | 6,96 | 04:31:00.0000000 | 04:29:00 |
AMERICA | BINGO | lun | 24/09/2018_198 | 09:00:00 | 04:26:00 | 10,44 | 04:26:00.0000000 | 04:34:00 |
AMERICA | BINGO | lun | 24/09/2018_197 | 09:00:00 | 04:20:00 | 10,44 | 04:20:00.0000000 | 04:40:00 |
AMERICA | BINGO | lun | 24/09/2018_196 | 09:00:00 | 04:20:00 | 20,88 | 04:20:00.0000000 | 04:40:00 |
Create something like this
If(Orario_Fine_Part >= Lunedì_open and Orario_Fine_Part <= Lunedì_open + MakeTime(1),
'Yay',
'Nay')
What is the expected output based on the sample data you have provided? Also, are you doing this in the script or front end of the app?
In the above example rows, none of your rows pass the condition, right? For all of the rows, Orario_Fine_Part is NOT between Lunedì_open and Lunedì_open+1 h, correct?
Okay, so what exactly do you want to see when the condition is NOT met or when it is met? Anther column where it says... Yay!! Condition Met. Nay!! it failed? Or something along those lines or you want to exclude those rows for your chart where the condition have not met? What exactly are you looking to do?
Create something like this
If(Orario_Fine_Part >= Lunedì_open and Orario_Fine_Part <= Lunedì_open + MakeTime(1),
'Yay',
'Nay')