I can't get Current date/time +hours: to work

[ramblin_bob]

I’m trying to get a repeating group to show events which occur later than the current date/time. That works just fine - Absolutes start >= Current date/time gives the desired response.

What I really want is to be able to show events that started within six hours before current date/time. Absolute start >= Current date/time +hours: -6 is invalid. I can’t even get the statement into the editor. I always get Current date/time +hours: (More…). When I click More I get the (Search) and the list of available options, none of which allow me to enter the -6.

Am I doing something wrong, or does this no longer work?

[ihsanzainal84]

You’ll need to use your mouse to select the string value "-6" in the dropdown.

[ramblin_bob]

There is no -6 in the dropdown. I made a new blank page with two text boxes, one for current and one for -6. Still cannot get the -6 to work.

[mario11]

You have to write it -6 and it will appear as the first choice in the dropdown…

[carlovsk.edits]

@mario11

You have to write it -6 and it will appear as the first choice in the dropdown…

[ramblin_bob]

carlovsk.edits, thank you very much. I don’t know why that works now, but watching your video did the trick. I had not been getting the popup with “-6” in it, and that was it.

YouTube is full of knowledge, so much of which is wrong.

[nocodeventure]

Arbitrary text converted to numbers is easier. Both work.

[ramblin_bob]

I don’t like the arbitrary text method. Yes it may be easier, but carlovsk.edits way lets me see at a glance what my constraint is. The text way is not obvious. Thanks for pointing that out.

[nocodeventure]

Agreed. It is easier though once you need calculations.

[ramblin_bob]

Good point. I don’t need calculations - yet…