Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Something is wrong with this expression, but can not figure out. Can you help me?
Only({$<Local={'Vila Recreio','Ponte Preta','Imbariê'},hora={">=$(=hora)<$(=hora + Time('00:40', 'hh:mm'))"}>}hora)
The expression should consider the date is between "hour" and hour + 40 minutes.
example:
My table:
Local | Sentido | Placa | dataHora |
---|---|---|---|
Vila Recreio | Rio de Janeiro | LLS0000 | 10/08/2013 08:30 |
Ponte Preta | Rio de Janeiro | LLS0000 | 10/08/2013 08:42 |
Piabetá | Rio de Janeiro | LLS0000 | 10/08/2013 11:16 |
Ponte Preta | Rio de Janeiro | LLS0000 | 10/08/2013 11:26 |
Ponte Preta | Rio de Janeiro | LLS0000 | 10/08/2013 12:59 |
Table of expression:
Data | Sentido | Placa | Entrada | Saída |
---|---|---|---|---|
10/08/2013 | Rio de Janeiro | LLS0000 | Piabetá - 11:16 | ? |
Hiii
Please Find attachment.
Vikas
Hello! Sorry but I need a solution using Expression. Anyway thanks for listening.
The issue is with the format i guess. You are trying to add minutes to hours. You have to be careful about the format of the hour field. Working on the below part of your expression should resolve your issue.
hora + Time('00:40', 'hh:mm')
Thank you for your attention, but what is wrong? I can not understand.
What i wanted to mean is, please check if the output of hora + Time('00:40', 'hh:mm') is of similar format as in hora field or not.
Edit: One more point, you are using Only() function which will return '-' (null) if there is more than one values. Do you really want the output to be so? If not, you might want to use Concat() function instead.